Oracle DBA, How To, Error, Cause and Action

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke


Cause:


During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.



Action:


Remove the constraints or specify CASCADE CONSTRAINTS.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)