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.
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