Re: Resetting HWM

From: Tom Pall <tom_at_cdproc.com>
Date: Wed, 15 Nov 2000 14:43:36 -0600
Message-Id: <10681.122175@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Resetting HWM</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I'm sure you can dump dump enough segment headers to =

figure</FONT></DIV>
<DIV><FONT size=3D2>out how and where to zip the data file.  This = might not=20
be supported, however.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:MohanR_at_STARS-SMI.com" =
title=3DMohanR_at_STARS-SMI.com>Mohan,=20
Ross</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, November 15, =
2000 2:01=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Resetting HWM</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>Folks, </FONT></P>
<P><FONT size=3D2>Anyone heard of a built-in or utility that lets =

me</FONT>=20

<BR><FONT size=3D2>reset a table's HWM?</FONT> </P>
<P><FONT size=3D2>I *know* there is something out there that =
let's</FONT>=20
<BR><FONT size=3D2>me do this short of a truncate or drop/create, =
but</FONT>=20
<BR><FONT size=3D2>I must have been hitting the crack pipe too hard=20
</FONT><BR><FONT size=3D2>lately and can't remember. </FONT></P>
<P><FONT size=3D2>TIA</FONT> </P>
<P><FONT size=3D2>Ross Mohan </FONT><BR><FONT =
size=3D2>(Certifiable)</FONT>=20 Received on Wed Nov 15 2000 - 14:43:36 CST