Home » Server Options » Streams & AQ » Working with two queues owned by different users (11g)
Working with two queues owned by different users [message #606152] Mon, 20 January 2014 07:50
Messages: 1
Registered: January 2014
Location: Armenia
Junior Member
Dear All,
I am new to AQ. I am implementing AQ within oracle database.
I have two users, test1 and test2.
I have queue1 owned by test1 user and queue2 owned by test2 user.
I want to implement AQ within this queues (queue2 dequeues messages of queue1). I have already implemented AQ for one queue (test2 enqueues and dequeues messages in the queue owned by test1 user.) And please tell me in which cases which one of this types of AQ should I use. Also I would like to know is there any way to dequeue messages from queue2 automatically when they enqueued by queue1 ?
Previous Topic: deleting a column at the apply process using a DML handler
Next Topic: Dequeue with RETENTION on queue not working as expected with DELAY
Goto Forum:

Current Time: Sat Dec 20 11:34:33 CST 2014

Total time taken to generate the page: 0.08531 seconds