Oracle DV - rule and rule set
Hi All
I am trying to delete a rule and rule set using the following commands but getting errors
As a dvowner oracle users
Note: All the application objects are part of T24 schema.
SQL> BEGIN
DVSYS.DBMS_MACADM.DELETE_RULE_SET(rule_set_name => 'RULE_SET_SYSTEM');
end ;
/
BEGIN
DVSYS.DBMS_MACADM.DELETE_RULE (rule_name => 'Rule_SYSTEM');
END ;
/
2 3 4 BEGIN
*
ERROR at line 1:
ORA-47346: Rule set RULE_SET_SYSTEM is used by one or more command rules.
ORA-06512: at "DVSYS.DBMS_MACADM", line 1297
ORA-06512: at line 2
SQL> SQL> 2 3 4 BEGIN
*
ERROR at line 1:
ORA-47325: Rule Rule_SYSTEM is used by one or more rule sets.