set sort_area_size=200000000;

and then try your query also tuning is very important.

regards
anandkl