ORA-31623: a job is not attached to this session via the specified handle
We recently faced a strange error when trying to import a schema through a database link on 11gR2.
shell> impdp system/*** SCHEMAS=LFXQAA02 directory=DATA_PUMP_DIR LOGFILE=liflexdp1.log NETWORK_LINK=tliflex01.world PARALLEL=2
Import: Release 11.2.0.1.0 - Production on Tue Jun 22 11:07:58 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning and Automatic Storage Management 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 3263
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 4488
ORA-06512: at line 1
After serval approaches we found out that streams_pool_size=0 was set.
alter system set streams_pool_size=40M scope=spfile;
restart DB and run import again..
There is also a Metalink note on this topic: 1080775.1