Hi,
Oracle 11.2.0.4
I was exporting using expdp a table of 1.3TB size using 7 parallelism
As disk space was getting filled up , i moved first few files exprt_01.dmp till exprt_09.dm out of 97 export dump files even before export was complete ( it took 24 hours) and at the end of export i received this error message ORA-31617: unable to open dump file (few lines below)
Will impdb recognize these files as the export of data was successful ?
Startup took 52 seconds
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Estimated 1 TABLE_DATA objects in 4 seconds
Total estimation using BLOCKS method: 1383. GB
Startup took 58 seconds
Processing object type TABLE_EXPORT/TABLE/TABLE
Completed 1 TABLE objects in 25 seconds
Processing object type TABLE_EXPORT/TABLE/COMMENT
Completed 23 COMMENT objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Completed 6 INDEX objects in 7 seconds
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Completed 1 CONSTRAINT objects in 4 seconds
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Completed 3 REF_CONSTRAINT objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Completed 1 TRIGGER objects in 7 seconds
ORA-31693: Table data object "GRS"."LOGSR" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "dumps/EXPORT_DP_01.dmp" for write
ORA-19505: failed to identify file "dumps/EXPORT_DP_01.dmp"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Completed 0 TABLE_EXPORT/TABLE/TABLE_DATA objects in 0 seconds
Master table "DBEXP"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for GGEXT.SYS_EXPORT_TABLE_01 is:
dumps/EXPORT_DP_01.dmp
dumps/EXPORT_DP_02.dmp
dumps/EXPORT_DP_03.dmp
dumps/EXPORT_DP_04.dmp
..... so on
Thanks