Re: resetting the HWM

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: ramick@xxxxxxxxxxx
  • Date: Mon, 26 Jun 2006 00:32:47 -0400

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
> 
> --
> //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

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


Other related posts: