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.