Empty table - many extents

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 11 Aug 2003 14:44:37 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7040EB516@lnewton.leeds.lfs.co.uk>

Hi Richard,

I feel a tantrum coming on now !
I'll bet you use COMPRESS=Y on your exports as well !!

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Richard Foote [mailto:richard.foote_at_bigpond.com] Posted At: Monday, August 11, 2003 2:00 PM Posted To: server
Conversation: Empty table - many extents Subject: Re: Empty table - many extents

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7040E995E_at_lnewton.leeds.lfs.co.uk...
> Hi Randy,
>
> To move the HWM down again, you need to truncate the table at some
point
> - hopefully when no-one is about to write some data !
>

Hi Norm,

I leverage the truncate command to reset the HWM all the time.

Cheers ;)

Richard Received on Mon Aug 11 2003 - 08:44:37 CDT