Advanced queuing : dequeing from remote database 2005-02-17 - By Sami Seerangan
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 (See ORA-24002.ora-code.com): QUEUE_TABLE
USSSD429.OBJMSGS80_QTAB@(protected) does not exist"
-- ---- ---- ---- ---- ---- ---- ---
SQL> EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name =>
'msg_queue',queue_table => 'usssd429.objmsgs80_qtab@(protected)');
BEGIN DBMS_AQADM.CREATE_QUEUE (queue_name =>
'msg_queue',queue_table => 'usssd429.objmsgs80_qtab@(protected)');
END;
*
ERROR at line 1:
ORA-24002 (See ORA-24002.ora-code.com): QUEUE_TABLE USSSD429.OBJMSGS80_QTAB@(protected) does not exist
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_AQADM_SYS", line 2555
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_AQADM", line 119
ORA-06512 (See ORA-06512.ora-code.com): at line 1
SQL> desc USSSD429.OBJMSGS80_QTAB@(protected)
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@(protected);
Synonym created.
On Thu, 17 Feb 2005 11:14:41 -0000, Nick Tilbury @ Northampton
<ntilbury@(protected)> 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
|
|
