ORA-00904: [message #355002] |
Wed, 22 October 2008 03:19 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
When executing the query i am getting the following error.
I searched for that error code but not success yet.
SELECT distinct
s.START_DATE,
p.propagation_name,
s.PROPAGATION_WINDOW,
s.NEXT_TIME,
s.LATENCY,
DECODE(s.SCHEDULE_DISABLED,
'Y', 'Disabled',
'N', 'Enabled') SCHEDULE_DISABLED,
s.PROCESS_NAME,
s.FAILURES,
sysdate,
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
AND (s.SCHEDULE_DISABLED='Y'
OR s.START_DATE > sysdate
OR PROCESS_NAME is not null
OR s.FAILURES > 0
OR ERROR_MESSAGE is not null
OR LAST_ERROR_MSG is not null);
Error
ORA-00904: "DBMS_LOGREP_UTIL"."CANONICAL_CONCAT": invalid identifier
Thanks,
|
|
|
Re: ORA-00904: [message #355005 is a reply to message #355002] |
Wed, 22 October 2008 03:42 |
panyam
Messages: 146 Registered: May 2008
|
Senior Member |
|
|
Hi ora,
It's not throwing any error for me :
SQL> SELECT distinct
2 s.START_DATE,
3 p.propagation_name,
4 s.PROPAGATION_WINDOW,
5 s.NEXT_TIME,
6 s.LATENCY,
7 DECODE(s.SCHEDULE_DISABLED,
8 'Y', 'Disabled',
9 'N', 'Enabled') SCHEDULE_DISABLED,
10 s.PROCESS_NAME,
11 s.FAILURES,
12 sysdate,
13 s.LAST_ERROR_MSG
14 FROM DBA_QUEUE_SCHEDULES s,
15 DBA_PROPAGATION p
16 WHERE p.DESTINATION_DBLINK = s.DESTINATION
17 AND s.SCHEMA = p.SOURCE_QUEUE_OWNER
18 AND s.QNAME = p.SOURCE_QUEUE_NAME
19 AND (s.SCHEDULE_DISABLED='Y'
20 OR s.START_DATE > sysdate
21 OR PROCESS_NAME is not null
22 OR s.FAILURES > 0
23 OR ERROR_MESSAGE is not null
24 OR LAST_ERROR_MSG is not null);
no rows selected
|
|
|
|
Re: ORA-00904: [message #355008 is a reply to message #355002] |
Wed, 22 October 2008 03:49 |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
My best guess will be you are missing grants to this package. Try to do a describe of this package DBMS_LOGREP_UTIL on both the schema/database.
Regards
Raj
[Edit:] Added package name
[Updated on: Wed, 22 October 2008 03:50] Report message to a moderator
|
|
|
|
Re: ORA-00904: [message #355011 is a reply to message #355009] |
Wed, 22 October 2008 03:53 |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Don't you think if an object is invalid oracle will try to recompile it when it is referred and if unsuccessful it will throw an exception ? However for some reason I am not able to find this package in the oracle reference manual.
Regards
Raj
[Updated on: Wed, 22 October 2008 03:54] Report message to a moderator
|
|
|