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