Sunday 28 July 2013

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

oradev@ctssd $ impdp system/manager DUMPFILE=ebsdev_scottconnect_datapump.dmp DIRECTORY=DATA_PUMP17  SCHEMAS=SCOTTCONNECT

Import: Release 11.2.0.3.0 - Production on Sat Jul 27 00:32:31 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, 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 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

Cause:Please increase the size of steams_pool_size parameter .

Solution: the size of the streams_pool_size parameter is too low or streams_pool_size parameter is not exists in pfile.

2 comments:

  1. CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there.


    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad

    ReplyDelete