RE: DBMS_LOGMNR_LOGREP_DICT error during full export
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <avramil@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 18:00:40 -0400
Did you rebuild the import and export views? IIRC (If I Recall =
Correctly) it is easy to miss that step in 8i to 9i and/or possibly have =
it fail in relative quiet. The scripts live in the usual place, IIRC it =
doesn't hurt to run them again, but YMMV (Your Mileage May Vary.) You've =
certainly got a test place to try this out.
I won't even ask why you're exporting every night.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Lou Avrami
Sent: Monday, June 06, 2005 2:09 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: DBMS_LOGMNR_LOGREP_DICT error during full export
Hi all,
I help administer a 9.2.0.5 database which is exported each night. The =
ful=3D
l
export process always receives the error below, related to
SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp.
Oracle Support suggest rerunning $ORACLE_HOME/rdbms/admin/dbmslmd.sql. =
Tha=3D
t
didn't seem to help.
this database was upgraded from 8i to 9i. I'm told that is when the =
proble=3D
m
first occurred.
Has anyone else encountered this problem? Can anyone suggest a =
solution? =3D
=3D20
It's not a critical issue - the export seems to finish ok otherwise, we
don't manifest this error at any other point. I'm handing this database =
of=3D
f
to another group soon, so I'd like to clean this up, if possible.
Thanks,
Lou Avrami
....
....
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_LOGMNR_LOGREP_DICT", line 994
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling =
=3D
=3D20
SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Direct Path ...
. . exporting table AQ$_INTERNET_AGENTS 0 rows =
exported
. . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows =
exported
Table DEF$_AQCALL will be exported in conventional path.
...
...
=3D20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
