Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with export after upgrade

Re: Problem with export after upgrade

From: Varad Acharya <vacharya_at_gw.ford.com>
Date: 1997/05/16
Message-ID: <337C658F.15B7@gw.ford.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US