Teradata Database Message 5951 - 5951 - Analytics Database - Teradata Vantage

Message

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.

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