Hi All

Currently we are on a test run of our application invloving advance queuing. The application involves queueing between 2 databases over a dblink.

when we create queue tables ,create queues, start queues, add subscribers, enable propogation on both db's . it works fine. but why doesnt queuing withstand a database restart.

The propogation to queues over dblinks fails , the moment i restart the databases. What could be the error .

I have to recreate all queue tables, queues, add subscribers , enable propagation all over again if i restart the db's.

My enqueuing process is initated on a trigger in a table with visibility on commit.
And i have dequeuing process on dbms_aq.listen.


kindly respond

Regards
Sushant