Re: Advanced queuing : dequeing from remote database

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 17 Feb 2005 09:50:10 -0500
Message-ID: <f09dd62805021706508125de3@mail.gmail.com>

Hi Nick,

As you suggested I tried creating queue based on table that is sitting on remote db, but I got the error saying that "ORA-24002: QUEUE_TABLE USSSD429.OBJMSGS80_QTAB_at_TESTA does not exist"

---

SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab_at_testa');
BEGIN DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab_at_testa');

END;   *
ERROR at line 1:

ORA-24002: QUEUE_TABLE USSSD429.OBJMSGS80_QTAB_at_TESTA does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2555
ORA-06512: at "SYS.DBMS_AQADM", line 119
ORA-06512: at line 1
 
 
SQL> desc USSSD429.OBJMSGS80_QTAB_at_TESTA
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 Q_NAME                                             VARCHAR2(30)
 MSGID                                     NOT NULL RAW(16)
 CORRID                                             VARCHAR2(128)
 PRIORITY                                           NUMBER
 STATE                                              NUMBER
 DELAY                                              DATE
 EXPIRATION                                         NUMBER
 TIME_MANAGER_INFO                                  DATE
 LOCAL_ORDER_NO                                     NUMBER
 CHAIN_NO                                           NUMBER
 CSCN                                               NUMBER
 DSCN                                               NUMBER
 ENQ_TIME                                           DATE
 ENQ_UID                                            NUMBER
 ENQ_TID                                            VARCHAR2(30)
 DEQ_TIME                                           DATE
 DEQ_UID                                            NUMBER
 DEQ_TID                                            VARCHAR2(30)
 RETRY_COUNT                                        NUMBER
 EXCEPTION_QSCHEMA                                  VARCHAR2(30)
 EXCEPTION_QUEUE                                    VARCHAR2(30)
 STEP_NO                                            NUMBER
 RECIPIENT_KEY                                      NUMBER
 DEQUEUE_MSGID                                      RAW(16)
 SENDER_NAME                                        VARCHAR2(30)
 SENDER_ADDRESS                                     VARCHAR2(1024)
 SENDER_PROTOCOL                                    NUMBER
 USER_DATA                                          MESSAGE_TYP
 
SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name         =>
'msg_queue',queue_table        => 'usssd429.objmsgs80_qtab');
 

PL/SQL procedure successfully completed.    

SQL> create synonym objmsgs80_qtab_r for usssd429.objmsgs80_qtab_at_testa; Synonym created.

On Thu, 17 Feb 2005 11:14:41 -0000, Nick Tilbury @ Northampton <ntilbury_at_vartec.co.uk> wrote:
> I would suggest you have the enqueue populate to the remote database queue =
> and deal with it locally.
>
> Nick

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 17 2005 - 09:54:00 CST