Re: oracle 10g how to resize the TEMP tablespace

Moritz Klein wrote:
> tpreto7_at_sapo.pt schrieb:
>
> > I have been trying to reduce the size of the TEMP tablespace,
> > unfortunately every time I try I get this error message
> > ORA-03297: file contains used data beyond requested RESIZE value
> > This is oracle 10G , in previous oracle versions I was able to reduce
> > with no issues the temp tablespace, what has happen with oracle 10g now
>
> For a start you could drop and recreate TEMP tablespace.
> Look at http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml
> for more info.
>
> hth, Moritz

Thank you! it worked

Teresa Received on Tue Oct 11 2005 - 19:36:30 CDT