Streams error- PLS-00201: identifier 'DBMS_AQADM' must be declared
- From: Prasad <p4cldba@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Nov 2007 11:26:47 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
