Ravi,
1)Temporary solution:
Around off-peak time do the following to get release of temp tablespace
alter tablespace temp offline;
Just after putting offline , run following immediately
alter tablespace temp online;
2) Create temp tablespace using tempfile like
create temporary tablespace temp
there is no problem. Oracle leaves the temp segment allocated (you
should be seeing only one) when your temp tablespace is created
"temporary" to save allocation time for future sorts.
It will go away when/if you shutdown and restart the database, but it
is SUPPOSED to be there
--- Nalla Ravi <
Thank you John,
The things is When we run a partucular query based on
view it takes around 1Gb space from TEMP tablespace
and is not being relased and from that point on words
It give space problem on other txns. that means It
didn't mark fro Free to use does it?
Ravi.
-- "Lau, John" <[EMAIL