Oracle DBA, How To, Error, Cause and Action

ORA-14417: Online DDL's cannot be used with deferrable constraints.

ORA-14417: Online DDL's cannot be used with deferrable constraints.


Cause:


An attempt was made to use the DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on constraint states (for example, deferrable, deferred) that was not allowed.



Action:


Using DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on constraints that are deferrable or deferred is illegal. Remove the ONLINE keyword from the statement.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)