Streams error- PLS-00201: identifier 'DBMS_AQADM' must be declared

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 8 Nov 2007 11:26:47 -0800
Message-ID: <666b99c70711081126k271e457dv666834e87d7e7a5c@mail.gmail.com>

All,

i have a streams setup that sends all the changes from a 9i db scott.emp to 10g db scott.emp . but the changes are not getting transmitted to 10g.

SELECT p.DESTINATION_DBLINK,
DECODE(s.SCHEDULE_DISABLED,
'Y', 'Disabled',
'N', 'Enabled') SCHEDULE_DISABLED,

s.PROCESS_NAME,
s.FAILURES,
s.LAST_ERROR_TIME,
s.LAST_ERROR_MSG

FROM DBA_QUEUE_SCHEDULES s, DBA_PROPAGATION p WHERE
p.DESTINATION_DBLINK = s.DESTINATION
AND s.SCHEMA = p.SOURCE_QUEUE_OWNER
AND s.QNAME = p.SOURCE_QUEUE_NAME
SQL> / DESTINATION_DBLINK

---

SCHEDULE PROCESS_ FAILURES LAST_ERR
-------- -------- ---------- --------
LAST_ERROR_MSG

---

DEV10G.US.ORACLE.COM
Enabled 11 04:25:59

ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_AQADM' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

I will appreciate any input.

thanks
-Prasad

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

Received on Thu Nov 08 2007 - 13:26:47 CST