Cannot create/drop Queue

From: Theo <theo.horn_at_za.unisys.com>
Date: Wed, 21 Jul 1999 21:57:02 GMT
Message-ID: <7n5fn7$9go$1@nnrp1.deja.com>

Hi. I had to drop and recreate my TOOLS tablespace after the unintentional drop of a datafile. :-( This forced me to recreate my replication setup, but without success. The problem is that I cannot drop or create the necessary queues. Here is the output from SVRMGR...

SVRMGR> execute dbms_aqadm.create_queue_table(QUEUE_TABLE =>  'SYSTEM.DEF$_AQCALL',QUEUE_PAYLOAD_TYPE => 'ANY',   STORAGE_CLAUSE =>' lob (user_data) store as (pctversion 0)');

ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_AQADM", line 1477
ORA-06512: at line 2

SVRMGR> drop table system.def$_aqcall;
drop table system.def$_aqcall

                  *

ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables SVRMGR> execute dbms_aqadm.drop_queue_table(QUEUE_TABLE
=> 'SYSTEM.DEF$_AQCALL' )

ORA-24002: QUEUE_TABLE SYSTEM.DEF$_AQCALL does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_AQADM", line 1774
ORA-06512: at line 2

So I cannot drop or create the queues, DEF$_AQCALL and DEF$_AQERROR! Can anyone please help? I hope it is something stupid.

Thanx

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 16:57:02 CDT