Teradata Database Message 5952 - 5952 - Analytics Database - Teradata Vantage

Message

WITH DELETE specified without a DROP RANGE.

Explanation

For an ALTER TABLE statement, if WITH DELETE is specified when altering partitioning expressions, at least one partitioning expression must be altered with a DROP RANGE[#Ln]. That is, WITH DELETE is not allowed when only adding ranges.

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.