Re: ORA-04031 during export??

Earvin C. Lim wrote:

> Hi there,
>
> When I was doing a full export on a database, after all the users'
> tables
> have been exported, there comes the error message:
>
> . exporting referential integrity constraints
> . exporting posttables actions
> EXP-00008: ORACLE error 4031 encountered
> ORA-04031: unable to allocate 20640 bytes of shared memory
> ("DBMS_REPCAT_MAS","P
> L/SQL MPCODE","BAMIMA: Grow Bam Buffer")
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 348
> ORA-06512: at "SYS.DBMS_SQL", line 134
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 64
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 115
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
>

It seems that your SGA is to much fragmented or indeed to small. Just try an
alter system flush shared_pool;
before the export. If it won't help restart the database with a larger amount of shared_memory.

Tobias. Received on Fri Aug 01 1997 - 00:00:00 CDT