Home » Server Options » Streams & AQ » Remove rule from the streams
Remove rule from the streams [message #198569] Tue, 17 October 2006 13:03
riah
Messages: 4
Registered: October 2005
Junior Member
Hi All,

I have a question regarding streams in removing the tables from the streams ...

To remove the table from the oracle streams ... i think we need to use dbms_streams_adm.remove_rule from the apply , capture, from propagation ..? ?

ex : to remove this from the table DEPARTMENTS3

BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name => 'DEPARTMENTS3',
streams_type => 'apply',
streams_name => 'appdev',
drop_unused_rule => true);
END;
/

BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name => 'DEPARTMENTS3',
streams_type => 'capture',
streams_name => 'capdev',
drop_unused_rule => true);
END;
/
BEGIN
DBMS_STREAMS_ADM.REMOVE_RULE(
rule_name => 'DEPARTMENTS3',
streams_type => 'propagation',
streams_name => 'prpdev',
drop_unused_rule => true);
END;
/

IS there any sequence to do this like first remove from the apply or remove from the propagation ? and do i have to disable the streams apply,capture,progation and enable it again after removing the rules for those tables .... ?


PLease advice in cleanup procedure for removing the rules..

Thanks in Advance..

Riah
Previous Topic: Please help me!
Next Topic: problem regarding dequeing in oracle aq
Goto Forum:
  


Current Time: Thu Mar 28 09:26:07 CDT 2024