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.