Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ORA-31643: unable to close dump file

Posted on 2009-07-08
2
Medium Priority
?
2,798 Views
Last Modified: 2013-12-19
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
Comment
Question by:basirana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 24813879
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
 

Accepted Solution

by:
basirana earned 0 total points
ID: 24830591
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question