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.