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-19908: datafile string has invalid checkpoint

1 Answers  


RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes

1 Answers  


ORA-38720: Missing log file number.

1 Answers  


ORA-12833: Coordinator's instance not a member of parallel_instance_group

1 Answers  


ORA-02452: invalid HASHKEYS option value

1 Answers  






PLS-00456: item 'string' is not a cursor

1 Answers  


CLSS-02207: error string getting status from vendor node monitor

1 Answers  


PCB-00320: VARYING host variable "string" is an Oracle extension

1 Answers  


ORA-39067: Unable to close the log file.

1 Answers  


SQL-01075: you are currently logged on

1 Answers  


ORA-23359: error on creating a ddl record for a repcatlog record

1 Answers  


LPX-00312: cannot construct XML PI with content: ~S

1 Answers  


Categories