Home » Server Options » Streams & AQ » Oracle Streams (10g R2 Unix Env)
Oracle Streams [message #514092] Fri, 01 July 2011 07:15 Go to next message
Messages: 80
Registered: September 2006


We use a uni-directional streams env involving 2 databases.

Need to know how the spilled msgs can be handled.

Will those msgs will be propagated and applied automatically?

How to handle failed transactions in the queues due to various errors with capture, propagation or apply processes.

In my application, we cannot re-execute the transactions at the source db if it got failed to replicate at the destination db.

Re: Oracle Streams [message #514101 is a reply to message #514092] Fri, 01 July 2011 08:16 Go to previous messageGo to next message
John Watson
Messages: 4687
Registered: January 2010
Location: Global Village
Senior Member
Hello - I think it may not be possible to answer such general questions here, but I'll try to give a few pointers.
First, by "spilled msgs" do you mean messages in a buffered queue that have been written to disc? If so, no worries - they will be propagated when possible. As for what you call "failed transactions", you must write your own message handlers to deal with them, certainly do not re-execute the transaction at the source.
Re: Oracle Streams [message #516655 is a reply to message #514092] Tue, 19 July 2011 21:20 Go to previous message
Messages: 3
Registered: January 2009
Junior Member
Hi ,

No need to wory much about spilled messages. Oracle will take care of it automatically.

Most offen you use to get ORA-01403 NO DATA FOUND error, below link may be useful for you to trouble shoot the above issue.


Thanks and Regards,
Previous Topic: Oracle CDC - WAITING FOR REDO
Goto Forum:

Current Time: Fri Oct 24 05:43:50 CDT 2014

Total time taken to generate the page: 0.11165 seconds