Message-Id: <10681.122175@fatcity.com> From: "Tom Pall" Date: Wed, 15 Nov 2000 14:43:36 -0600 Subject: Re: Resetting HWM This is a multi-part message in MIME format. ------=_NextPart_000_0446_01C04F12.6FBE6C10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Resetting HWMI'm sure you can dump dump enough segment headers to figure out how and where to zip the data file. This might not be supported, = however. ----- Original Message -----=20 From: Mohan, Ross=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, November 15, 2000 2:01 PM Subject: Resetting HWM Folks,=20 Anyone heard of a built-in or utility that lets me=20 reset a table's HWM?=20 I *know* there is something out there that let's=20 me do this short of a truncate or drop/create, but=20 I must have been hitting the crack pipe too hard=20 lately and can't remember.=20 TIA=20 Ross Mohan=20 (Certifiable)=20 ------=_NextPart_000_0446_01C04F12.6FBE6C10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Resetting HWM
I'm sure you can dump dump enough segment headers to = figure
out how and where to zip the data file.  This = might not=20 be supported, however.
----- Original Message -----
From:=20 Mohan,=20 Ross
To: Multiple recipients of list ORACLE-L =
Sent: Wednesday, November 15, = 2000 2:01=20 PM
Subject: Resetting HWM

Folks,

Anyone heard of a built-in or utility that lets = me=20
reset a table's HWM?

I *know* there is something out there that = let's=20
me do this short of a truncate or drop/create, = but=20
I must have been hitting the crack pipe too hard=20
lately and can't remember.

TIA

Ross Mohan
(Certifiable)=20