Home » RDBMS Server » Server Administration » Cannot drop DEF$_AQCALL (oracle 9i, 10g, OS: windows xp)
Cannot drop DEF$_AQCALL [message #320781] Fri, 16 May 2008 04:24 Go to next message
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
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

Previous Topic: What does Auxillary Instance mean?
Next Topic: enq: TX - row lock contention
Goto Forum:
  


Current Time: Fri Dec 09 13:46:52 CST 2016

Total time taken to generate the page: 0.11321 seconds