1 person found this helpful
Kindly check DBA_QUEUES view.
Just a follow up question. Does oracle automatically create an exception queue table for every new queue table you create? Just a little confused there.
e.g. queue table created is
QUEUE_TABLE_NAME , a corresponding AQ$
QUEUE_TABLE_NAME_T exception queue will be created. Is that all automatic upon
what happens when you actually test it?
Sorry. Haven't tested it yet. We don't have Oracle AQ here in our office. Will be working on it in our client next week. Now I want to learn as much as I can before we start working on it hands on.
Use New queue for your new application.
Yes, an exception queue is created as part of a Queue table creation.
Please refer to below document to know what are the default objects created when a queue table is created.
Doc Id 224027.1 --- OBJECTS CREATED WHEN CREATING A QUEUE TABLE