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