Hi Tamil: I added another 500MB to temp space(altogether 1GB) and all free when i started the query again..
This table has 21 million rows of each row avg of upto 250 bytes.. No OLTP is going on this table.. still since 20 minutes it is going on and since morning i have used up close to 3 hours of time on this.. i have a few more tables like this..
what is the best way out?? Thanks..

Jeff: I still have to do that ctablock.sql. Do you have any docs on the same, so i know what i am doing?
Thx