15.00 - 5736 DROP RANGE for level %VSTR removes all ranges. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

5736 DROP RANGE for level %VSTR removes all ranges.

Explanation:

An ALTER TABLE statement with DROP RANGE[#Ln] but without ADD RANGE[#Ln] is attempting to remove all the ranges from the partitioning expression. This is not allowed.

Generated By:

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