Hello everyone

I posted a question last week that my export failed. I got a response tried everything but still I am getting the same errors

This is what I am doing
exp SYSTEM/password FULL=y FILE=I:\data_exp\dba.dmp GRANTS=y ROWS=y log=I:\data_exp\exp_log.log

I tried doing it as sys but I am getting the same thing

I tried running catproc and catexp
But still the same error occurs

Also I was told to run owmcpkgb.plb to recreate SYS.LT_EXPORT_PKG package body, but I couldn't find the file anywhere in the oracle directory.


So I am getting the following errors - this is the end of the log file.

this is the beggining of the log file

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "ORDSYS.ORDTEXP" 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 ORDSYS.ORDTEXP.schema_info_exp


And this is the end

. . exporting table PURCHASE_SONGS 0 rows exported
. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
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_AQ_IMPORT_INTERNAL" 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 1076
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully


I didn't notice the front part before, I think this is the key but I am not an oracle guru so I don't have the knowledge to fix it.

Can anyone help?