AQ - Can't drop queue table

From: <ronensh_at_my-deja.com>
Date: Sat, 07 Oct 2000 23:44:39 GMT
Message-ID: <8roch7$val$1@nnrp1.deja.com>

Hello,

I created a QUEUE TABLE at my schema.
At some stage I tried dropping it through dbms_aqadm.drop_queue_table, and it returned successesfuly - but the QUEUE TABLE was not deleted.

I cant drop the table ( ORA .. please use dbms_aqadm). I cant recreate it through dbms_aqadm.create_queue_table ( ORA-00955: name is already used by an existing object). And I even couldn't drop schema.

I didn't find the queue in any system table.

Need help.

TIA.
Ronen.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 07 2000 - 18:44:39 CDT