Hi
SQL> exec dbms_aqadm.drop_queue_table('AQ$_QTABLE');
BEGIN dbms_aqadm.drop_queue_table('AQ$_QTABLE');
END;
*
ERROR at line 1:
ORA-24012: cannot drop QUEUE_TABLE, some queues in TEST.AQ$_QTABLE have not
been dropped
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2670
ORA-06512: at "SYS.DBMS_AQADM", line 192
ORA-06512: at line 1
hOW TO DROP this AQ table.
Reply urgent
Paresh