Tuesday, 8 September 2015

ORA-31693 ORA-29913 ORA-31640 ORA-19505 ORA-27037 While Perform IMPDP

While working on Development Environment to load data into table . I got Dump file from production DBA team and Then I tried to Load Data into Dev database. While I tried to load it I got below errors.

ORA-31693: Table data object "XXXXXXX"."XXXXXX" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31640: unable to open dump file "/xxxx/xxxx/xxxxxxxxxxx.dmp" for read
ORA-19505: failed to identify file "/xxxxxxx/xxxxxx/xxxxxxxxxxx.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory


-- I have tried multiple times to import with above command by re executing but i had same issue. After researched


~~~~~~
Cause :-
~~~~~~


From 11.2, DataPump new parameter CLUSTER is introduced.


CLUSTER : Default=Y


Purpose :

Determines whether Data Pump can use Oracle Real Application Clusters (RAC) resources and start workers on other Oracle RAC instances.Syntax and Description : CLUSTER=[Y | N]
Solution

To force DataPump to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTER=N.

Example:

expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_clus%U.dmp CLUSTER=N PARALLEL=3
impdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_clus%U.dmp CLUSTER=N PARALLEL=3



After added CLUSTER=N in IMPDP command its succeed.



No comments:

Post a Comment