SET INTERVAL is not legal on this table.

Solution ID:ORA-14759

Type: Oracle

Cause

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.

Actions

ALTER TABLE SET STORE IN is only valid for Interval partitioned tables. Ensure that the table by Interval.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3674506


https://community.oracle.com/message/1889712


Browse all solutions to database errors from Oracle, MS SQL, or MySQL