Assuming that none of the extents are currently used, you can issue the "alter tablespace" command below to clean up temp.
alter tablespace temp
default storage (pctincrease 0);
This will tell smon to clean up the segments in the tablespace that are not used.




Reply With Quote