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

can i use only one queue for multiple destination databases?

thanks

tweety
Re: multiple destination [message #110933 is a reply to message #110777] Fri, 11 March 2005 03:42 Go to previous message
Frank Naude
Messages: 4581
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.

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


Current Time: Wed Dec 04 13:09:53 CST 2024