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

Translate this page

Oracle Database Error ORA-01981

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

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.

User Posts for ORA-01981

Be the first to post a message...

Post your own questions, answers and tips for ORA-01981

No registration required

CAPTCHA Image New word