Please Help! - Export Problem

From: Josh Pinkert <flush_at_radix.net>
Date: 1996/06/16
Message-ID: <1733.6741T1351T1142_at_radix.net>#1/1

I'm doing an Oracle 6 for OS/2 to Oracle 7.1 for Netware migration and am down to one final problem (I think!). I'm getting the following error when exporting a user's tables (which will be done nightly once the database goes into production).

Here is what I get in my export log...

Connected to: Oracle7 Server Release 7.1.3.3.2 - Production Release PL/SQL Release 2.1.3.2.1 - Production

About to export specified users ...
About to export INFOAGE's objects ...
.exporting job queues
.exporting refresh groups and children
.exporting database links
.exporting sequence numbers
.exporting cluster definitions
.about to export INFOAGE's tables ...
.exporting table COMMENTS

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_SQL" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 16
ORA-06512: at line 1
EXP-00222:

System error message 759255631
System error message: No such file or directory

.exporting table COUNTER
EXP-00008: ORACLE error 4068 encountered

*<...lots of the same stuff deleted, just for other tables...>*

.exporting synonyms
.exporting views
.exporting stored procedures
.exporting referential integrity constraints
.exporting triggers
.exporting posttable actions

Export terminated successfully with warnings.

So, basically, I get this error and cannot trace it down. I can't find anything on the "DBMS_SQL" table/package/procedure and it won't give me anything when I use the 'describe' command.

Any suggestions/fixes would be greatly appreciated...

--
flush_at_Radix.Net
Josh Pinkert
--

Received on Sun Jun 16 1996 - 00:00:00 CEST