...i attempted to restart the db server and even cleared a bit of room in temp, but to no avail. The table is rather big....almost 1GB of disk space and about 1/2 a million rows. I am thinking I may still not have enough room in /tmp (how much space is enough?), but was looking for other solutions. 'check table' showed I was in good shape. Could this be another issuse? any ideas?