Home » Server Options » Streams & AQ » Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs
Oracle Stream is working for INSERTs, but does not on UPDATEs & DELETEs [message #130804] Tue, 02 August 2005 11:06 Go to next message
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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?
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 Go to previous message
rsethy
Messages: 11
Registered: February 2008
Junior Member
Do it by handling the dml operation using procedure.
Regards.

Raghu
Previous Topic: 9.2.0.4 to 10.2.0.1
Next Topic: AQ propagation over internet
Goto Forum:
  


Current Time: Thu Mar 28 20:38:10 CDT 2024