Hi

Were do we specify temporary tablespace for sorting operations of long-runniing query?
in general if we have small query it doesn'nt give a problem ,if we have big query it gives error why is it so ,how we can handle it ....

Thanks
lnr