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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center