15.00 - 5951 Specified ADD RANGE level %VSTR is not the same as level %FSTR for the corresponding DROP RANGE. - 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)

5951 Specified ADD RANGE level %VSTR is not the same as level %FSTR for the corresponding DROP RANGE.

Explanation:

For an ALTER TABLE statement, if ADD RANGE#Ln is specified with a DROP RANGE[#Ln] in an alter partitioning expression clause, n must specify the same level as the default or specified level of that DROP RANGE[#Ln].

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 re-quest.