Teradata Database Message 5731 - 5731 - Analytics Database - Teradata Vantage

Message

DROP RANGE and ADD RANGE for level %VSTR are not allowed; partitioning expression, if any, at that level is not a RANGE_N function or involves comparison of character or graphic data.

Explanation

For an ALTER TABLE statement, DROP RANGE[#Ln] and ADD RANGE[#Ln] clauses are only allowed if the table is partitioned solely with a RANGE_N partitioning expression at the level being altered and: i. Does not involve comparision of character or graphic data. or ii. Involves only special partitions (e.g. NO RANGE, UNKNOWN, NO RANGE OR UNKNOWN).

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.