Schema Compare was used to compare Grant of two schemas. The sync script shows the following command:
REVOKE REFERENCES, UPDATE ON <schema 1>.<table> FROM <schema 2>;
Running the above command in target schema will result in the following error:
"ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke"
The generated REVOKE REFERENCES command is not complete and cannot be executed.
WORKAROUND:
Add the "CASCADE CONSTRAINTS" parameter to the REVOKE REFERENCES command as below prior to running it:
REVOKE REFERENCES, UPDATE ON <schema 1>.<table> FROM <schema 2> CASCADE CONSTRAINTS;
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
