Teradata Database Message 9249 - 9249 - Analytics Database - Teradata Vantage

Message

The altering of RANGE_N definition with CURRENT_DATE/CURRENT_TIMESTAMP is not allowed.

Explanation

On a table that has PPI defined using CURRENT_DATE or CURRENT_TIMESTAMP, only ALTER TABLE <tablename> TO CURRENT can be submitted to alter the PPI definition using a new date or timestamp. ALTER TABLE with ADD or DROP RANGE clause must not be used in this case.

Generated By

OPD modules

For Whom

End user

Notes

None

Remedy

Use ALTER TABLE <tablename> TO CURRENT.