Teradata Database Message 5733 - 5733 - Analytics Database - Teradata Vantage

Message

DROP RANGE specifies no existing range, part of an existing range, or a nonexisting NO RANGE, NO RANGE OR UNKNOWN, or UNKNOWN partition.

Explanation

For an ALTER TABLE statement, an existing range cannot be partially specified by DROP RANGE. That is, existing ranges must be entirely within the dropped ranges or entirely outside the dropped ranges. Also, at least one existing range must be dropped if ranges are specified to be dropped. If the NO RANGE, NO RANGE OR UNKNOWN, or UNKNOWN partition is specified to be dropped, it must exist.

Generated By

RES modules.

For Whom

End User.

Notes

None

Remedy

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned primary index rules and resubmit the request.