Re: phantom queue table - solved

2001-08-31 Thread Richard Ji
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 this before? Any suggestions are welcome. Richard Ji -- Please see the official ORACLE-L FAQ: http

phantom queue table

2001-08-30 Thread Richard Ji
. 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 San Diego

Re: phantom queue table

2001-08-30 Thread Brian McGraw
) 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. It seems I got a phantom queue table. Has anyone seen