Re: oracle 10g how to resize the TEMP tablespace

From: EdStevens <quetico_man_at_yahoo.com>
Date: 11 Oct 2005 17:39:24 -0700
Message-ID: <1129077564.377871.325050@z14g2000cwz.googlegroups.com>

tpreto7_at_sapo.pt wrote:
> Hi
>
> 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
>
> Thank you,
> Teresa

But why bother? Unless the ts got WILDLY larger than needed and you're recovering significant amounts of disk that is needed elsewhere .... Received on Tue Oct 11 2005 - 19:39:24 CDT