Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
I logged with user OWRNAME and db DBNAME
I trying to drop queue table using this query:
begin DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'OWRNAME.AQ$_TABLE2DROP',force => TRUE); end;
I have received this message:
ORA-24002: QUEUE_TABLE OWRNAME.AQ$_TABLE2DROP does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3013
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1
I try to find a existing AQ$_TABLE2DROP using this query:
select * from dba_tables where owner='OWRNAME' order by table_name
The AQ$_TABLE2DROP exist!
OWRNAME AQ$_TABLE2DROP 0 0 0 0 N 0 0 0 0 0 1 1 N ENABLED 0 04/04/2014 18:11:09 NO IOT N N NO DISABLED YES NO DISABLED NO DISABLED DISABLED
What is the problem?
THX