SKM,

I'm not sure whether this will work, but I think I can remember
having a similar problem with a temporary tablespace filling up. Even though the contents were temporary, the extents were not being released. To get Oracle to release them try the following:-

alter tablespace temp default storage (pctincrease 0)
/

(In my case, my pct increase was set to 0 anyway, so all this does is to wake Oracle up and release the temp extents) So, just use a parameter like pctincrease and use the alter tablespace statement to set it to what it is already set as. ie, don't change anything, just issue the command and see what happens.

cheers

chris.