We are getting the below error while doing EXPDP kindly some one suggest.
ORA-39127: unexpected error from call to export_string :=SYS.LT_EXPORT_PKG.schema_info_exp('SYS',1,1,'10.02.00.00.00',newbloc
ORA-04031: unable to allocate 46640 bytes of shared memory ("shared pool","LTADM","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.LTADM"
ORA-06512: at "SYS.LT_EXPORT_PKG", line 843
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419
I had google it and sharing with u the answer i got.
Oracle Data Pump uses Streams functionality to communicate between processes. If the SGA_TARGET initialization parameter is set, then the STREAMS_POOL_SIZE initialization parameter is automatically set to a reasonable value.
If the SGA_TARGET initialization parameter is not set and the STREAMS_POOL_SIZE initialization parameter is not defined, then the size of the streams pool automatically defaults to 10% of the size of the shared pool.
When the streams pool is created, the required SGA memory is taken from memory allocated to the buffer cache, reducing the size of the cache to less than what was specified by the DB_CACHE_SIZE initialization parameter. This means that if the buffer cache was configured with only the minimal required SGA, then Data Pump operations may not work properly. A minimum size of 10M is recommended for STREAMS_POOL_SIZE in order to ensure successful Data Pump operations.