Solved

EXPDP error

Posted on 2009-07-08
3
1,681 Views
Last Modified: 2013-12-19
I am trying to do export using datapump but it gave below error message.
How can I fix?
 As we are having smaller disk space I am taking two different destination for dumpfile.
Can I get some help.

Thanks
--
--EXPDP 
--
 
expdp FUNTOST@BCWWW \
TABLES=VFDATA.WWW_MT,VFDATA.PLU_MT,VFDATA.WWW_PLU_AN \
DUMPFILE=dmpdir1:WWW1_07_09%U.dmp, dmpdir2:WWW2_07_09%U.dmp \
NETWORK_LINK=pos_WWW \
EXCLUDE=INDEX \
LOGFILE=dmpdir1:expWWW.log \
JOB_NAME=expWWW1
 
 
--
-- Error
--
 
.dmp NETWORK_LINK=pos_source EXCLUDE=INDEX LOGFILE=dmpdir1:expwww.log JOB_NAME=expwww1
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 "VFDATA"."www_PUB_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/wwwdump/www1_07_0901.dmp"
ORA-19510: failed to set size of 524550 blocks for file "/d090/wwwdump/www1_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 "VFDATA"."www_MT"                           195.6 MB 1639834 rows
. . exported "VFDATA"."PUB_MT"                           66.17 MB 1639834 rows
Master table "C02067"."EXPwww1" successfully loaded/unloaded
******************************************************************************
Dump file set for C02067.EXPwww1 is:
  /d090/wwwdump/www1_07_0901.dmp
  /d032/oradata/source/wwwdump/www2_07_0901.dmp
Job "FUNTOST"."EXPwww1" 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
3 Comments
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 24809658
have you tried adding
ESTIMATE_ONLY=Y
to see how big the dump file will be ?
and then checking if you have enough space for it ?
0
 

Accepted Solution

by:
basirana earned 0 total points
ID: 24809690
The problem is fixed providing file size parameter

Thanks
0
 

Author Comment

by:basirana
ID: 24830602
The problem is I dint specified the filesize. After specifiing filesize I was able to resolve the issue.

Thanks
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

717 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