Re: oracle 10g how to resize the TEMP tablespace

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Wed, 12 Oct 2005 01:24:51 +0200
Message-ID: <dihhbm$41q$1@news1.zdv.uni-mainz.de>

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 Received on Tue Oct 11 2005 - 18:24:51 CDT