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.

Leave a comment