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.
Oracle 26ai
ORA-08705
Error Message
CASCADE CONSTRAINTS must be specified to perform REVOKE ASSERTION REFERENCES.