Home » RDBMS Server » Server Administration » Remove rule from the streams
Remove rule from the streams [message #198568] Tue, 17 October 2006 13:02
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: spool result
Next Topic: RUSSIAN_RUSSIA.UTF8 language parameter is not working in windows registry
Goto Forum:
  


Current Time: Wed Dec 07 04:36:34 CST 2016

Total time taken to generate the page: 0.09129 seconds