Teradata Database Message 5750 - 5750 - Analytics Database - Teradata Vantage

Message

ADD RANGE level %VSTR is not in increasing order.

Explanation

For an ALTER TABLE statement, if ADD RANGE#Ln without a DROP RANGE[#Ln] is specified in other than the first alter partitioning expression clause, n must be at least one more than the default or specified level associated with the preceding alter partitioning expression clause.

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.