Re: resetting the HWM

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 26 Jun 2006 00:32:47 -0400
Message-Id: <1151296367l.2705l.0l@medo.noip.com>

On 06/25/2006 10:20:55 PM, ramick wrote:
> 9205 - RH Linux x86
> Is there any way to lower the HWM other than truncate or drop?
> TIA
>
> --
> http://www.freelists.org/webpage/oracle-l

Move it (alter table move). Also, there have been some nasty bugs with ass managed tablespaces in Oracle 9, one of which was causing index corruption. I'm not sure why would you want to use ass managed tablespaces (thanks Pete S., wherever you are) unless you are using RAC? At any rate, you should probably upgrade to 9.2.0.8 ASAP or even sooner.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jun 25 2006 - 23:32:47 CDT