Adding to above, if the user runs one more create table as selct query, it would take 60% more. User is going to get an Error when the temp tablespace is filled. I want to free up the temp tablespace. is there any way I can do that??

When i issue below command I see free space 100%

select SUBSTR(SYSDATE,12) "TIME",Current_Users, Total_Blocks, Used_Blocks, Free_Blocks,
Round(100 * free_blocks / total_blocks,2) "% FREE"
from V$SORT_SEGMENT;


But if my freespace was 20% then what would be solution. I have my PCTINCREASE As 100 and initial and next 8mb.