ORA-24001 (merged) [message #390884] |
Tue, 10 March 2009 03:26 |
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 #390893 is a reply to message #390888] |
Tue, 10 March 2009 03:40 |
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 #390900 is a reply to message #390897] |
Tue, 10 March 2009 04:08 |
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 #454169 is a reply to message #390884] |
Tue, 04 May 2010 05:50 |
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
|
|
|