Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with export after upgrade

44 views
Skip to first unread message

Ken Hensel

unread,
May 15, 1997, 3:00:00 AM5/15/97
to

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

Varad Acharya

unread,
May 16, 1997, 3:00:00 AM5/16/97
to

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

0 new messages