Teradata Database Message 5734 - 5734 - Analytics Database - Teradata Vantage

Message

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.

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.