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.
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??