Oracle DBA, How To, Error, Cause and Action

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

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


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.



Action:


Use SET INTERVAL only on a valid table.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)