• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3116
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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