We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

EXPDP error

basirana
basirana asked
on
Medium Priority
2,051 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

Comment
Watch Question

Geert GOracle dba
CERTIFIED EXPERT
Top Expert 2009

Commented:
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 ?
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
The problem is I dint specified the filesize. After specifiing filesize I was able to resolve the issue.

Thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.