-
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
-
have you defined a shared_pool_reserved_size ???
-
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
