Home » Oracle DBA » Deleting existing rule sets after removing Oracle Streams Configuration

Deleting existing rule sets after removing Oracle Streams Configuration

Deleting existing rule sets after removing Oracle Streams Configuration

 DECLARE
  CURSOR VIN Is
    Select RULESET_NAME From DBA_RULESETS Where OWNER = 'STRMADMIN';
     
BEGIN
 For I In VIN LOOP   
 BEGIN
  DBMS_RULE_ADM.DROP_RULE_SET(
    rule_set_name => 'STRMADMIN.'||I.RULESET_NAME,
    delete_rules  => TRUE);
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  END LOOP;   
END;
/

Oracle Streams