I am trying to defragment table tfgld418.

While loading this table I am getting error 1179. There is enough free space available on the file system where the tempdb space is located.

Please let me know what could be cause of this error.


Regards


Chingi

> finderr 179
-179 ISAM error: No free disk space for sort.

While performing a sort, the database server did not find enough
contiguous free disk space to create necessary temporary files. You
might have insufficient disk space and need to make more disk space
available before you run the program again. You might have made an
error when you specified the names of temporary dbspaces in DBSPACETEMP
or directory names in PSORT_DBTEMP. Check the spelling of your
temporary space names as specified in DBSPACETEMP. If you specified
multiple temporary dbspaces, check that you used colons (:) or commas
(,) as delimiters.