PROBLEM:      

      While taking export or import  , you may face below issue.

oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS directory=TESTDIR table_exists_action=truncate

 Import: Release 12.1.0.2.0 – Production on Sun Apr 10 14:30:23 2016
 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
 Username: / as sysdba
 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3905
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 5203
ORA-06512: at line 1
 
ERROR IN ALERT LOG:
Errors in file /u01/app/oracle/diag/rdbms/TEST/TEST/trace/TEST_ora_1862.trc (incident=58353):
ORA-04031: unable to allocate 448 bytes of shared memory (“streams pool”,”unknown object”,”streams pool”,”kwqbsinfy:cco”)
Incident details in: /u01/app/oracle/diag/rdbms/TEST/TEST/incident/incdir_58353/TEST_ora_1862_i58353.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Dec 31 10:38:06 2018
Sweep [inc][58353]: completed
Sweep [inc2][58353]: completed
Mon Dec 31 10:38:07 2018

SOLUTION:

Increase the stream_pool_size to 64 M.
SQL> show parameter stream
 
NAME                                 TYPE        VALUE
———————————— ———– ——————————
streams_pool_size                    big integer 0 
 
 
SQL> alter system set streams_pool_size=64M scope=both;
 System altered.
 
Else configure automatic memory management(AMM) by setting memory_target parameter.