Not able to import in oracle 11.1.7
Posted on 2011-10-26
Few days back got a export dump from production db and transfered back to test environment to be imported back to test db. but get this error message..
impdp szc2525/singh_1011 DIRECTORY=CMR_3120943 dumpfile=POHDS2S_BETA_SE2D.dmp schemas=PROD_BETA REMAP_SCHEMA=PROD_BETA:SHDS01 exclude=GRANT
Import: Release 18.104.22.168.0 - 64bit Production on Wednesday, 26 October, 2011 17:59:50
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, Real Application Clusters, 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 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line 1
Looked at the dba_datapump_jobs too and found no job runinig. No invalid objects too.
Is there any way around ? any suggestion ?
Can we import the same dump through any other way to the db. Its very critical...