15.00 - 5731 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. - 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)

5731 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.

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.