Re: Problem with export after upgrade

Ken Hensel wrote:
>
> I recently upgraded from Oracle 7.0.15 to 7.1.4. Now export now longer
> works.
> Here is an example section from running exp:
>
> . exporting table EMPLOYEE_SECURITY
> EXP-00008: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> . exporting table FC_PERSON_IN_ROOM
> EXP-00008: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> . exporting table FC_ROOM
> EXP-00008: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
>
> It seems to get several of these same errors. If anyone has seen this
> before and can help out I'd appreciate it.
>
> Thanks

Run the scripts that loads the dbms_export_extentsion package for the version of the ORACLE server you are running export against.These scripts are located in the $ORACLE_HOME/rdbms/admin/ directory

dbmspexp.sql & prvtpexp.sql Received on Fri May 16 1997 - 00:00:00 CDT