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
 

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.