Thank you for responding so promptly. We received similar advice from three
other respondents.
We took the recommended actions, but the problem remains.
<holmesb_at_my-deja.com> wrote in message news:7ij8sg$epj$1_at_nnrp1.deja.com...
> In article <7ii6d0$mi9$1_at_news.islandnet.com>,
> "Jans Diemer" <jans_at_islandnet.com> wrote:
> > 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?
> >
> > In svrmgrl try running catalog.sql, catproc.sql, and
> catexp.sql. They are (in UNIX) in $ORACLE_HOME/rdbms/admin.
> Another approach would be to try recompiling the invalid objects.
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Sat May 29 1999 - 10:29:53 CDT
