Hi All,

I have the default temporary tablespace which is 99% full. It couldn't allocate more extents. Can you please suggest all possible ways to clear of the temp segments..

I have read that Temporaray segments created are cleared or removed when the instance is restarted. But it doesn't seem to happen.

Help please!!!

Thanks is advance.

Nandu