Database Administration (MOSC)

MOSC Banner

Oracle DV - rule and rule set

edited Jan 2, 2020 8:40AM in Database Administration (MOSC) 2 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center