Oracle dbf problem

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 24 Jul 2002 11:14:52 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70269794A@lnewton.leeds.lfs.co.uk>

Richard,

I forgot to mention, the only way I know to get the HWM down is to truncate the table, but that moves the HWM down to the size of the INITIAL extent - so I'm back in the same position of having a spare 60 odd blocks in my table that I cannot reclaim - unless I rebuild the table from scratch.

Cheers,
Norman.

---

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


-------------------------------------

Received on Wed Jul 24 2002 - 05:14:52 CDT