Oracle Error ORA-14759: SET INTERVAL is not legal on this table.

Oracle Error Message

ORA-14759: SET INTERVAL is not legal on this table.

Reason for the Error

SET INTERVAL clause was specified. ALTER TABLE SET INTERVAL is only legal on a range partitioned table with a single partitioning column. Additionally, this table cannot have a maxvalue partition and cannot be the parent table for any reference partitioned tables.

Solution

Use SET INTERVAL only on a valid table.