Home » Server Options » Streams & AQ » multiple destination
multiple destination [message #110777] Thu, 10 March 2005 04:48 Go to next message
Messages: 1
Registered: March 2005
Junior Member

can i use only one queue for multiple destination databases?


Re: multiple destination [message #110933 is a reply to message #110777] Fri, 11 March 2005 03:42 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Yes, see the Oracle Streams Concepts and Administration Guide:

"...the queue from which the events are propagated is called the source queue, and the queue that receives the events is called the destination queue. There can be a one-to-many, many-to-one, or many-to-many relationship between source and destination queues."

"...a single source queue may propagate events to multiple destination queues, and a single destination queue may receive events from multiple source queues."

"If the source queue is configured to propagate an event to multiple destination queues, then the event remains in the source queue until each destination queue has sent confirmation of event propagation to the source queue."

Best regards.

Previous Topic: AQ propagation failures
Next Topic: Delete Handler
Goto Forum:

Current Time: Tue Aug 16 02:33:15 CDT 2022