OraFAQ Forum: Streams & AQ » Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs

Home » Server Options » Streams & AQ » Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs

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

Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #130804]

Tue, 02 August 2005 11:06

Tanjob
Messages: 1
Registered: July 2005

Junior Member

I have configured a table on the source database. This database is running on ARCHIVELOG mode. A supplemental Log Group has been added to the selected table.

After we finished configuration of the Stream steps. We ran our tests and found only the INSERTed records were sent to the target database. There were no sign of the UPDATEd & DELETEd records.

Has anyone got a knowledges in this area?

Thank you for any assistant.

Report message to a moderator

Re: Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #150744 is a reply to message #130804]

Fri, 09 December 2005 06:57

asangapradeep
Messages: 128
Registered: October 2005
Location: UK

Senior Member

hi,
if you have can you please give me few urls with info on how to implement stream replication.

thank you

Report message to a moderator

Re: Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #319182 is a reply to message #150744]

Fri, 09 May 2008 04:59

rsethy
Messages: 11
Registered: February 2008

Junior Member

Hi,

Please find the links to configure Oracle streams and also there is metalink notes available to configure links in Oracle 9i & 10g streams

http://www.oracle-base.com/articles/9i/Streams9i.php

Thanks.

Raghu

Report message to a moderator

Re: Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #329251 is a reply to message #319182]

Tue, 24 June 2008 13:16

shrinika
Messages: 306
Registered: April 2008

Senior Member

I followed the same in the link. But DDL is replicating. DML is not. I posted the result in another thread Stream is not working... Need help

Can any one help me on this?

Report message to a moderator

Re: Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #329307 is a reply to message #130804]

Wed, 25 June 2008 00:26

rsethy
Messages: 11
Registered: February 2008

Junior Member

Do it by handling the dml operation using procedure.
Regards.

Raghu

Report message to a moderator

Previous Topic:	9.2.0.4 to 10.2.0.1
Next Topic:	AQ propagation over internet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:28:39 CST 2024