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.
Oracle LazyDBA home page