GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Unable to drop streams rule set

edited Oct 8, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi Oracle Support Community,

While checking invalid database objects, I have found many invalid objects of type RULE SET belonging to 'strmadmin' user. Oracle streams were configured long time before, but it is no more required. Therefore, I am trying to drop RULE SET by logging in with SYS user, but it is giving me error:

Oracle Database Server Enterprise Edition 11.2.0.4.0 on RHEL 6

SQL> BEGIN

  2  DBMS_RULE_ADM.DROP_RULE_SET(

  3  rule_set_name => 'strmadmin.<'RULE_SET_NAME'>,

  4  delete_rules  => TRUE);

  5  end;

  6  /

BEGIN

*

ERROR at line 1:

ORA-24170: STRMADMIN.<'RULE_SET_NAME'> is created by AQ, cannot be

dropped directly

ORA-06512: at "SYS.DBMS_RULE_ADM", line 158

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