Re: HELP! Export-00008

From: <kal121_at_my-deja.com>
Date: Tue, 31 Oct 2000 23:47:47 GMT
Message-ID: <8tnln2$m1n$1@nnrp1.deja.com>

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. Received on Tue Oct 31 2000 - 17:47:47 CST