Re: Cannot create/drop Queue

Theo

The problem is that you have dangling queue tables as a result of the datafile drop. The only thing you can do now is call Support to see how to get around it.

HTH. Pete

Theo wrote:

> 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.

--
Regards

Pete

Received on Wed Jul 21 1999 - 17:30:21 CDT