15.00 - 5734 ADD RANGE for level %VSTR overlaps existing ranges or partitions. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5734 ADD RANGE for level %VSTR overlaps existing ranges or partitions.

Explanation:

For an ALTER TABLE statement after applying DROP RANGE[#Ln] and expansion of ranges with EACH clauses, the ranges specified by ADD RANGE[#Ln] must not overlap existing ranges and added partitions must not conflict with or be the same as existing partitions. For example, an UNKNOWN partition may not be added if NO RANGE OR UNKNOWN partition or an UNKNOWN partition is already in the partitioning expression for the table.

Generated By:

RES modules.

For Whom:

End User. DR62813-bessc

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.