dropping queue tables.

hi freinds,

I am working in 8i on win 2k.

I am trying to delete queue tables using following procedure.

BEGIN
DBMS_AQADM.DROP_QUEUE_TABLE (queue_table=> 'DEF$_PUSHED_TRANSACTIONS',force => TRUE);
END

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:

Code:

---


Note:151613.1
Subject:  ALERT: Running CATALOG.SQL Invalidates Queues


---

Sam