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-26522: rpc execution error

1 Answers  


RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE

1 Answers  


ORA-02235: this table logs changes to another table already

1 Answers  


QSM-01509: equivalence, string, matched query text

1 Answers  


ORA-00346: log member marked as STALE

1 Answers  






NID-00103: Missing password in connect string "string"

1 Answers  


ORA-13798: Parameter string cannot be NULL.

1 Answers  


ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

1 Answers  


ORA-00607: Internal error occurred while making a change to a data block

1 Answers  


ORA-02372: data for row: string

1 Answers  


ORA-32505: too many watchpoints

1 Answers  


DRG-12435: highlight table allocation failed

1 Answers  


Categories