How to fix the Oracle error ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke?

In this post, you’ll learn more about the Oracle ErrorORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.

How to fix the Error ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke ?

You can fix this error in Oracle by following the below steps

Remove the constraints or specify CASCADE CONSTRAINTS.