ORA-31623: a job is not attached to this session via the specified handle

impdp parfile=imp1.par

Import: Release 11.2.0.1.0 - Production on Mon Jan 31 12:54:56 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
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 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1





Solution:
~~~~~~~~~~~~~~~~~~~~~~
clear the invalid objects in sys schema

increrase the stream pool size to fix the issue






SQL>sho parameter stream

Name               TYPE         Value
--------------     ------------ ----------------
Stream_pool_size   Big Integer   0                



SQL>alter system set   Stream_pool_size=200m scope=spfile;
or
SQL>alter system set   Stream_pool_size=200m;

System altered.



SQL>sho parameter stream

Name               TYPE         Value
--------------     ------------ ----------------
Stream_pool_size   Big Integer   200M