Re: ORACLE error 4068 encountere...

Sounds like possibly a data dictionary problem. Connect internal and re-run catalog.sql and catproc.sql. I don't know what happens, but I have seen the export get confused and re-running these two scripts seems to fix it.

Kenny Gump

Jans Diemer wrote in message <7ii6d0$mi9$1_at_news.islandnet.com>...
>When exporting tables for eventual importing elsewhere, we get the table
>structure only, and the following list ensues. This occurs for every table
>in the database. Where can we find the cause?
>About to export GEORGE's objects...
>. exporting database links
>. exporting sequence numbers
>. exporting cluster definitions
>. about to export GEORGE's tables via Conventional Path ...
>. . exporting table NNNNNNNNN where NNNNNN
>represents the table names
>EXP-00008: ORACLE error 4068 encountered
>ORA-04068: existing state of packages has been discarded
>ORA-04063: package body "SYS.DBMS_SQL" has errors
>ORA-06508: PL/SQL: coull not find program unit being called
>ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 18
>ORA-06512: at line 1
>The last table sequence is followed by
>. exporting synonyms
>. exporting views
>. exporting stored procedures
>. exporting triggers
>. exporting posttables actions
>. exporting snapshots
>. exporting snapshot logs
>. expoprting job queues
>. exporting refresh groups and children
>Export terminated successfully with warnings.
>Can anyone point us in the right direction?
>
>
Received on Thu May 27 1999 - 06:42:17 CDT