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