Temporary tablespace filled up

[srt]

How can I make the temp tablespace free up.
User ran a query last night and has taken 80 % of tablespace. but temp tablespace has not been freed up. If you restart the database the temp tablespace gets freed up, but is there any other way how a tablespace can free up.

[OracleDoc]

Bet you're looking at the temp space through OEM aren't you.

[srt]

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.

[srt]

I am looking at temp space through TOAD.

[bensmail]

create a new one and drop the old.

[srt]

create a new one and drop the old.

That cannot be solution every time and I guess thats not correct practice.

[davey23uk]

twmp will always show as full

are you getting unable to extend errors?

[srt]

I am getting unable to extentd error
ORA-1652: unable to extend temp segment by 1024 in tablespace TEMP

[Horace]

How big is tablespace TEMP? Can you increase it's size?

Has the users CTAS sql got a cartesian join in it?

[srt]

Tablespace is 8g.