ORA-31643: unable to close dump file

I am trying to do export into multiple directories but it failed because of following errors.
I am not sure how to resolve

Thanks
expdp D20777@BCGRE \
TABLES=FDDATA.FDU_MT,FDDATA.PLU_MT,FDDATA.FDU_PLU_AN \
DUMPFILE=dmpdir1:FDU1_07_09%U.dmp, dmpdir2:FDU2_07_09%U.dmp \
NETWORK_LINK=pos_GRE \
EXCLUDE=INDEX,STATISTICS \
LOGFILE=dmpdir1:expFDU.log \
JOB_NAME=expFDU1
filesize=2G
 
 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 22.69 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "FDDATA"."FDU_PLU_AN" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLECLOSE callout
ORA-31643: unable to close dump file "/d090/FDUdump/FDU1_07_0901.dmp"
ORA-19510: failed to set size of 524550 blocks for file "/d090/FDUdump/FDU1_07_0901.dmp" (blocksize=4096)
ORA-27046: file size is not a multiple of logical block size
Additional information: 2
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 99
ORA-29913: error in executing ODCIEXTT
. . exported "FDDATA"."FDU_MT"                           195.6 MB 1639834 rows
. . exported "FDDATA"."PLU_MT"                           66.17 MB 1639834 rows
Master table "D20777"."EXPFDU1" successfully loaded/unloaded
******************************************************************************
Dump file set for D20777.EXPFDU1 is:
  /d090/FDUdump/FDU1_07_0901.dmp
  /d032/oradata/GRE/FDUdump/FDU2_07_0901.dmp
Job "D20777"."EXPFDU1" completed with 1 error(s) at 14:50:32

Open in new window

basiranaAsked:
Who is Participating?
 
basiranaConnect With a Mentor Author Commented:
This was problem with disk space disk1 and disk2 are not evenly distributed as disk2 small the file got created but was not able to extend bcoz of free sapce...I have cleared some of the old dumps and with sufficient free space on both disk the files are evenly distributed.

Thanks
0
 
schwertnerCommented:
I think it is not correct to Export using NETWORK_LINK and using files.
I said you that you can IMPDP using NETWORK_LINK and in this case no
files are created. The records are put into the database directly.
0
All Courses

From novice to tech pro — start learning today.