文档解释
ORA-41706: a condition referenced in rule conditions may not be deleted
Cause: An attempt was made to delete a condition when one or more rule conditions refer to it.
Action: Delete the rules before deleting the conditions.
ORA-41706错误是由于在删除数据对象时,试图删除其中一个条件被参考到的规则条件引起的。
官方解释
当删除数据对象时,如果该数据对象中有一个条件被参考到规则条件中 ,则会引发错误ORA-41706:条件参考到规则条件,不能被删除。
解决方法:
1、使用dbms_rls.dislable_maint来禁用规则条件。
2、删除引用的数据对象。
3、使用dbms_rls.enable_maint来启用条件条件。