Home » Server Options » Streams & AQ » ORA-24001 (merged)
ORA-24001 (merged) [message #390884] Tue, 10 March 2009 03:26 Go to next message
ramya29p
Messages: 146
Registered: November 2007
Location: Chennai
Senior Member
Unable to create the Oracle Queue. When i execute the below Procedure getting Error as Table Already Exists. But the table does not exist.
SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'GWTB_FCUBS_NOTIF_XML_Q',queue_payload_type => 'sys.aq$_jms_text_message');

begin DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'GWTB_FCUBS_NOTIF_XML_Q',queue_payload_type => 'sys.aq$_jms_text_message'); end;

ORA-24001: cannot create QUEUE_TABLE, FCCTCB61.GWTB_FCUBS_NOTIF_XML_Q already exists
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2830
ORA-06512: at "SYS.DBMS_AQADM", line 58
ORA-06512: at line 1

Please tell me how to resolve this problem?
Re: ORA-24001 (merged) [message #390888 is a reply to message #390884] Tue, 10 March 2009 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I tend to trust Oracle, prove it is wrong.
For instance, try to drop the queue table.

Regards
Michel
Re: ORA-24001 (merged) [message #390893 is a reply to message #390888] Tue, 10 March 2009 03:40 Go to previous messageGo to next message
ramya29p
Messages: 146
Registered: November 2007
Location: Chennai
Senior Member
when i execute the Drop_QUEUE_TABLE , getting error as queue_table doesnot exist
SQL> /

begin DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'GWTB_FCUBS_NOTIF_XML_Q'); end;

ORA-24002: QUEUE_TABLE FCCTCB61.GWTB_FCUBS_NOTIF_XML_Q does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4103
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1
Re: ORA-24001 (merged) [message #390897 is a reply to message #390893] Tue, 10 March 2009 03:55 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

I think you can cross check using data dictionary table; right

http://download.oracle.com/docs/cd/B19306_01/server.102/b14257/aq_views.htm

Babu

[Updated on: Tue, 10 March 2009 03:56]

Report message to a moderator

Re: ORA-24001 (merged) [message #390900 is a reply to message #390897] Tue, 10 March 2009 04:08 Go to previous messageGo to next message
ramya29p
Messages: 146
Registered: November 2007
Location: Chennai
Senior Member
Hi,
I checked the Table user_QUEUE_TABLES & user_queues. but there is not record for the table name 'GWTB_FCUBS_NOTIF_XML_Q'
Re: ORA-24001 (merged) [message #390901 is a reply to message #390900] Tue, 10 March 2009 04:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

 select queue_table,owner from dba_queue_tables where queue_tables='GWTB_FCUBS_NOTIF_XML_Q' 


Check using DBA_QUEUE_TABLES

Babu
Re: ORA-24001 (merged) [message #454169 is a reply to message #390884] Tue, 04 May 2010 05:50 Go to previous message
sap_arul
Messages: 27
Registered: November 2005
Location: BANGALORE
Junior Member
Hi,

Please check whether GWTB_FCUBS_NOTIF_XML_Q is present in the User_objects (select * from user_objects where object_name='GWTB_FCUBS_NOTIF_XML_Q').

Because we should not keep the same name for Queue objects and our normal objects.

Arul

Previous Topic: Replication of data between different schemas at table level
Next Topic: How to keep Advanced Queuing clean (remove dead subscribers)?
Goto Forum:
  


Current Time: Thu Mar 28 17:53:04 CDT 2024