it's doesn't show in the ALL/DBA_QUEUE_TABLES.
>
> I tried to drop it and the dbms_aqadm.drop_queue_table() executes
> successfully. But when I try to create it again it gave me the same
> message.
>
> It seems I got a phantom queue table.
>
> Has anyone seen th
e a queue table (AQ) and it tells me the queue table
> already exists. But it's doesn't show in the ALL/DBA_QUEUE_TABLES.
>
> I tried to drop it and the dbms_aqadm.drop_queue_table() executes
> successfully. But when I try to create it again it gave me the same
> message.
ssage.
It seems I got a phantom queue table.
Has anyone seen this before? Any suggestions are welcome.
Richard Ji
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
