Re: HELP! Export-00008

From: Hugh Patrick <hugh.patrick_at_virgin.net>
Date: Thu, 23 Nov 2000 23:28:53 +0000
Message-ID: <3A1DA835.7F2D4C0C@virgin.net>

kal121_at_my-deja.com wrote:

> You have an invalid package: sys.dbms_aq_import_internal
>
> You'll probably have to re-compile this by running one of the catalog
> scripts. I'm not sure which one.
>
> More troublesome is why this package got errors to begin with.
>
> In article <8tnh7h$bh9$1_at_dahlia.singnet.com.sg>,
> kowho_at_singnet.com.sg (Ho) wrote:
> > I tried to export my database without success. The messages are :
> > EXP-00008: ORACLE error 4068 encountered
> > ORA-04068 : existing state of packages has been discarded
> > ORA-04063 : has errors
> > ORA-04063 : package body "sys.dbms_aq_import_internal" has errors
> > ORA-06508: PL/SQL: could not find program unit being called
> > ORA-06512: at line 1
> > ORA06512: at "SYS.DBMS_SYS_SQL", line 787
> > ORA06512:at:"SYS.DBMS_SQL", line 328
> > ORA06512:at "SYS.DBMS_EXPORT_XTENTION", line 82
> >
> > EXP-00000: export terminated unsuccessfully
> >
> > How to resolve this problem ?
> >
> > Many thanks for your help in advance.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

catexp.sql?

Regards,
Hugh Received on Thu Nov 23 2000 - 17:28:53 CST