OCI-08705
CASCADE CONSTRAINTS must be specified to perform REVOKE ASSERTION REFERENCES.
Cause
During this REVOKE, some SQL assertions that reference this table cannot be dropped. To perform this automatically, CASCADE CONSTRAINTS must be specified.
Action
Drop SQL assertions that reference this table or specify CASCADE CONSTRAINTS.