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
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