Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: error during export in oracle 8.0.3

Re: error during export in oracle 8.0.3

From: Christer Rehnström <chr_at_algonet.se>
Date: 1998/01/11
Message-ID: <34B8D55F.31B3@algonet.se>#1/1

Haim Stots wrote:
>
> Hello ,
> i got an error during export using oracle 8.0.3 :
> ---------------------------------------------------------------
> . exporting posttables actions
> EXP-00008: ORACLE error 4045 encountered
> ORA-04045: errors during recompilation/revalidation of
> SYS.DBMS_AQ_IMPORT_INTERNAL
> ORA-06552: PL/SQL: Compilation unit analysis terminated
> ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
> ORA-06512: at "SYS.DBMS_SQL", line 328
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
>
> Any hints ?
>
> Stots
>
> stots_at_elbit.co.il

I have experienced this behaviour, especially the error "ORA-06508: PL/SQL: could not find program unit being called" when there isn't enough free space in the shared pool of the SGA.

Try to flush the SGA (be careful if this is an oltp database) or increase the shared pool in the SGA (needs a database restart). Received on Sun Jan 11 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US