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

Oracle Error Message

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

Reason for the Error

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

Solution

Remove the constraints or specify CASCADE CONSTRAINTS.