dropping queue tables.
I am working in 8i on win 2k.
I am trying to delete queue tables using following procedure.
DBMS_AQADM.DROP_QUEUE_TABLE (queue_table=> 'DEF$_PUSHED_TRANSACTIONS',force => TRUE);
But the system displays following error.
ORA-24002 : QUEUE TABLE COMPILETEST.DEF$_PUSHED_TRANSACTIONS does not exist
ORA-06512 : AT "SYS.DBMS_AQADM_SYS",line 2663
ORA-06512 : AT "SYS.DBMS_AQADM_SYS",line 192
ORA-06512 : at line 2
As such there are no queue tables in SYS. The q tables r existed in
SYSTEM and COMPILETEST users.
I would like to drop COMPILETEST user. Before doing it so, I must delete q tables from this user.
How can it be..?
immediate reply is appreciated.
Is it a production database? Looks like your dictionay is corrupted. You might have too resolute to following the following Notes from metalink:
Subject: ALERT: Running CATALOG.SQL Invalidates Queues
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width