| Error | ORA-01981 |
Description | 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. |