How to release the space in temporary tablespace.I was not able to release it.I tried coalesce pct_icrease 0 and 1.It didnt work.
which oracle version are u in,
For dictionary managed tamporary tablespace it would not clear until and unless u restart the database.
If you have a temporary segment within, and no user that release it..this is a problem, try this:
change the next extent of the tablespace storage (bigger than the actual) then try coalesce.
let me know