TEMP tablespace - URGENT...
Dear Gurus,
My Temp tablespace shows it has 3GB filled. How can i reduced it??
Coalescing doesn't make any diff. Please let me know how i get back
the space??
My Temp tablespace is Locally Managed. PCT_INCREASE value is 0.
Can i change change PCTINCREASE to 1 and then back to 0. It should coalesce itself?
I use this command but i got the error
SQL> alter tablespace temp
2 default storage (
3 pctincrease 1);
alter tablespace temp
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
How to use this command? can u please advise me,
Thanks in advance,
Iyyappan.M