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;
/
