AQ$ table. How and when it is created.
This is sample which I used to create a queue.
We used the similar DDL to create queue in 9i database.
Every time we would get a pair of queues:
MY_QUEUE
AQ$_MY_QUEUE_TBL_E
But in 11g database, I only get MY_QUEUE.
Did I do something wrong in 11g or it is supposed to be this way?
thx
Sean.
BEGIN
SYS.DBMS_AQADM.CREATE_QUEUE
(
QUEUE_NAME => 'TEST_USER.MY_QUEUE'
,QUEUE_TABLE => 'TEST_USER.MY_QUEUE_TBL'
,QUEUE_TYPE => SYS.DBMS_AQADM.NORMAL_QUEUE
,MAX_RETRIES => 5
,RETRY_DELAY => 0
,RETENTION_TIME => 86400
);
END;
/
BEGIN
SYS.DBMS_AQADM.START_QUEUE
(
QUEUE_NAME => 'TEST_USER.MY_QUEUE'
,ENQUEUE => TRUE
,DEQUEUE => TRUE
);
END;
/