Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31210: DBMS_LDAP: PL/SQL - LDAP get_dn error.

1 Answers  


ORA-28584: heterogeneous apply internal error

1 Answers  


NZE-28821: No input buffer provided.

1 Answers  


QSM-00502: OCI error

1 Answers  


VID-00714: internal error

1 Answers  






ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


KUP-02004: quoted string too big

1 Answers  


ORA-14319: DEFAULT cannot be specified with other values

1 Answers  


ORA-01220: file based sort illegal before database is open

1 Answers  


ORA-02379: profile string already exists

1 Answers  


PCC-02415: Cannot manipulate Object attributes in an OBJECT GET or SET

1 Answers  


ORA-07391: sftopn: fopen error, unable to open text file.

3 Answers  






Categories