一个基于模式级别的streams复制里面包含了几个schema,现在要删除一个,可以用下面的方法!
-- Get the rule_name with the sql: select rule_name,rule_owner from dba_rules;
BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name =>'&rule_name',
streams_type =>'CAPTURE',
streams_name =>'STREAMS_CAPTURE'
);
END;
/
BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name =>'&rule_name',
streams_type =>'PROPAGATION',
streams_name =>'STREAMS_PROPAGATION'
);
END;
/
BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name =>'&rule_name',
streams_type =>'APPLY',
streams_name =>'STREAMS_APPLY'
);
END;
/