OraFAQ Forum: Server Administration » Remove rule from the streams

Home » RDBMS Server » Server Administration » Remove rule from the streams

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	spool result
Next Topic:	RUSSIAN_RUSSIA.UTF8 language parameter is not working in windows registry

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 00:34:03 CST 2025