Skip to content
August 26, 2016 / doganay

ORA-19510: failed to set size of … blocks for file


Problem:

ORA-29913: error in executing ODCIEXTTABLECLOSE callout
ORA-31643: unable to close dump file "/dir1/file1.dmp"
ORA-19510: failed to set size of 789216 blocks for file "/dir1/file1.dmp" (block size=4096)
ORA-27037: unable to obtain file status


When:

expdp


Solution:

1.
Remove compression when expdp if you are using.

2.
Remove “COMPRESSION ENABLED” keyword if exists when creating external table if you are using one.

3.
Use non CIFS FS for expdp if you’re using.
CIFS FS does not support datapump operations.

4.
Check your free size and mount parameters of your FS.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: