Symptoms: Received the following error while trying to import data using impdp.
ORA-39097: Data Pump job encountered unexpected error -4031
ORA-39065: unexpected master process exception in MAIN
ORA-04031: unable to allocate 2024 bytes of shared memory ("streams pool","unknown object","streams pool","kodpaih3 image")
Cause: Usually this happen because Data Pump operations use the Oracle Streams pool and the size of the stream has no enough size for the demand.
It is also possible that this pool is set to 0.
Solution: Set the parameter STREAMS_POOL_SIZE > 0, thus guarantee there is a minimum size for the streams pool when data pump requires it.
eg: alter system set streams_pool_size=150m;
Restarted the IMPDP operation and enjoy.
