Cannot drop DEF$_AQCALL [message #320781] |
Fri, 16 May 2008 04:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
Hello all...
In oracle 10g, I can successfully drop two tables : DEF$_AQCALL and DEF$_AQERROR using follwing statement :
Quote: | EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'test2.DEF$_AQCALL' , FORCE => TRUE);
EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'test2.DEF$_AQERROR' , FORCE => TRUE)
|
but when i try the same in oracle 9i, i cannot..
Anyone please guide in this...
Regards,
Dipali
|
|
|
Re: Cannot drop DEF$_AQCALL [message #320786 is a reply to message #320781] |
Fri, 16 May 2008 04:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
In oracle 9i,
following is the error messages returned when i m trying to drop those two tables.
SQL> EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'test_user.DEF$_AQCALL' , FORCE => TRUE)
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'test_user.DEF$_AQCALL' , FORCE => TRUE); END;
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE TEST_USER.DEF$_AQCALL does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2979
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1
SQL> select * from tab where tname like 'DEF%';
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEF$_AQCALL TABLE
DEF$_AQERROR TABLE
DEF_AULT TABLE
|
|
|