OraFAQ Forum: Server Administration » Cannot drop DEF$

Home » RDBMS Server » Server Administration » Cannot drop DEF$_AQCALL (oracle 9i, 10g, OS: windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot drop DEF$_AQCALL [message #320781]

Fri, 16 May 2008 04:24

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

Report message to a moderator

Re: Cannot drop DEF$_AQCALL [message #320786 is a reply to message #320781]

Fri, 16 May 2008 04:35

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 22:53:31 CST 2024