can not drop queue tables

[dragon99]

When I do
select table_name from user_tables; It gives me
VLAD_IN_T
VLAD_OUT_T
but when I do
drop table vlad_in_t
it tells me
SQL> drop table vlad_in_t;
drop table vlad_in_t
*
ERROR at line 1:
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
when I do
SQL> execute DBMS_AQADM.DROP_QUEUE_TABLE('VLAD_IN_T');
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE('VLAD_IN_T'); END;

*
ERROR at line 1:
ORA-24002: QUEUE_TABLE HUBV2.VLAD_IN_T does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2663
ORA-06512: at "SYS.DBMS_AQADM", line 192
ORA-06512: at line 1

I need to drop the table VLAD_IN_T, can anyone tell me how to? why I can not drop the table while it does show up in user_table view? Thanks.

[akkerend]

Does it show up in USER_QUEUE_TABLES ?

[dragon99]

No, it only shows in user_tables;

[dragon99]

I resolve the issue from oracle support,
It is a known bug with oracle 8i, which will be fixed in
8.1.7. For the time being, you could do
SQL>alter session set events '10851 trace name context forever, level 2 ';
and then do drop table tablename; you will be O.K.