Database 11gr2
Rac 11gr2
When trying to expdp the below error appear :
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel parallel=4
ORA-31693: Table data object “CS_XM_TEMP”.”CS_XM_TEMP_CC” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/u01/expdp /dump_test.dmp” for write
ORA-19505: failed to identify file “/u01/expdp/dump_test.dmp”
ORA-27037: unable to obtain file status
You need to make sure of the below :
– Folder exdp_folder should be exists on the both nodes with same path.
even if you try to connect using tnsnames it will generate error so solution
-Remove parallel from your expdp command to be like this
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel
-Use Cluster Option in expdp
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel cluster=n
Thank you
Osama mustafa
Technology Geek 