Thanks to Brian, The queue table somehow still have an entry in the system.aq$_queue_tables. After removing that entry everything is fine. Richard Ji >>> [EMAIL PROTECTED] 08/30/01 17:10 PM >>> Actually, yes. I don't have the specific details - that would be helpful, right?? - but after contacting Oracle support, I had to remove an entry from an internal table. Check out Metalink - I'm sure it's on there. Brian Richard Ji wrote: > Hi all, > > I try to create 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. > > 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, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- -------------------------------------- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | |------------------------------------| | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
