Re: Advanced queuing : dequeing from remote database
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: ntilbury@xxxxxxxxxxxx
- Date: Thu, 17 Feb 2005 09:50:10 -0500
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@TESTA does not exist"
------------------------------------
SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name =>
'msg_queue',queue_table => 'usssd429.objmsgs80_qtab@testa');
BEGIN DBMS_AQADM.CREATE_QUEUE (queue_name =>
'msg_queue',queue_table => 'usssd429.objmsgs80_qtab@testa');
END;
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE USSSD429.OBJMSGS80_QTAB@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@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@testa;
Synonym created.
On Thu, 17 Feb 2005 11:14:41 -0000, Nick Tilbury @ Northampton
<ntilbury@xxxxxxxxxxxx> wrote:
> I would suggest you have the enqueue populate to the remote database queue =
> and deal with it locally.
>
> Nick
--
//www.freelists.org/webpage/oracle-l
Other related posts:
