Can anyone help. I have exported many times but with Oracle 9.2.0.6 on Solaris every instance is getting these errors when I export. I have tried running catalog, catproc, catrepr, catrep, utlrep, etc... I have tried compiling the packages, dropping etc. I do have invalid objects that I cant seem to get valid.
Can someone at least report back to me that they can export in 9.2.0.6 on Solaris.
exp system/manager full=y file=test.dmp log=test.log
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.sc
hema_info_exp
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_REPCAT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 88
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 139
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Oracle LazyDBA home page