Press "Enter" to skip to content

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