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-07612: $GETUAI failed in retrieving the user's clearance level

1 Answers  


ORA-09801: Unable to get user ID from connection

1 Answers  


ORA-01752: cannot delete from view without exactly one key-preserved table

1 Answers  


ORA-31221: DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.

1 Answers  


ORA-32333: disable table scn update for Materialized view

1 Answers  






ORA-30951: Element or attribute at Xpath string exceeds maximum length

1 Answers  


NZE-29141: Cannot import in the der format.

1 Answers  


TNS-00558: Entrust login failed

1 Answers  


ORA-28521: no heterogeneous capability information available

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


ORA-07473: snclrd: read error when trying to read sgadef.dbf file.

1 Answers  


SQL*Loader-00251: Sort devices are not used by SQL*Loader

1 Answers  






Categories