ORACLE ERROR 4031

[Mark_Woz]

Hi All

Upon running an export I am getting :

EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory
("DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 16
ORA-06512: at line 1
. . exporting table DEF$_CALLDEST

EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory
("DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 59
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 93
ORA-06512: at line 1

. . exporting table DEF$_DEFAULTDEST
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 42
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 93
ORA-06512: at line 1

. . exporting table DEF$_DESTINATION
EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory
("DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 59
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 93
ORA-06512: at line 1

. . exporting table DEF$_ERROR
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 42
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 93
ORA-06512: at line 1

The export terminates with warnings. What do I do to get rid
of the error ?

Thanks in Advance
MarkWoz

[pipo]

have you defined a shared_pool_reserved_size ???

[hnagia]

maybe your shared pool settings are small and can not suffis the need of the Operation , what are the values of the shared_pool_size and shared_pool_reserved_size