Oracle Solution for Error ora-01981
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
What triggered the Error:
During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.What should we do to fix it:
Remove the constraints or specify CASCADE CONSTRAINTS.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
