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-31613: Master process string failed during startup.

1 Answers  


ORA-00223: convert file is invalid or incorrect version

1 Answers  


ORA-02285: duplicate START WITH specifications

1 Answers  


NCR-03018: NCRO: Failed to make RSLV connection

1 Answers  


ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.

1 Answers  






ORA-01538: failed to acquire any rollback segment

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


ORA-19709: numeric parameter must be non-negative integer

1 Answers  


ORA-28237: seed length too short

1 Answers  


PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  


NNL-00281: Scheduled restart to occur in string

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


Categories