Hi fellow DBAs:
I had a weird export problem that was solved by a metalink SR, I wanted
to share the solution:
Problem:
- DMSYS schema was missig.
- EXFSYS schema was corrupted
so the export routines didn't work.
Solution:
For the DMSYS problem, the explanation lies in the metalink Note 304449.1
For the EXFSYS problem, the explanation lies in the metalink Note 258618.1
Once I followed the recommendations and procedures, the errors were gone.
By the way, thanks to Sharp Keith who mahe the suggestion that I should
try:
try running catexp in the ORAHOMe/rdbms/admin folder.
This script was not the right one, but you put me in the right track, TNX!
-----Original Message-----
From: Israel Laureano Lazcano
[Email address protected]
Sent: Saturday, November 17, 2007 11:39 AM
To: LazyDBA Discussion
Subject: Exporting problems
Hi fellow DBAs and other dark forces:
The normal exp routines arenīt working for me they seem to work, but at
the end gives me these errors:
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "EXFSYS.DBMS_EXPFIL_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "EXFSYS.DBMS_EXPFIL_DEPASEXP", line 61
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling
DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp
and doesn't generate any DMP files. Looking at the messages and in the
DB, I found DMSYS schema didn't exist, so I tried to copy from other of
my DBs.
EXP say it can't export the schema because the user DMSYS isn't a "valid
user", EXPDP seemed to work, but when I IMPDPed the generated file, it
imported 0 objects.
I'm doing no backups because EXP fails, and I don't trust EXPDP (just
imagine I IMPDP some DMP, or a table or someting, it will import 0
objects with 0 info and I will have 0 job). Weird.
I know I can backup my database using other methods: RMAN, cold backups,
etc. But for lack of devices, space and computing power, I can only use
some exp routine (exp or expdp). Can anyone help me?
Israel.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************
Oracle LazyDBA home page