Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2884
  • Last Modified:

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

0
basirana
Asked:
basirana
1 Solution
 
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
 
basiranaAuthor 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now