Re: Oracle dbf problem

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 24 Jul 2002 21:26:57 +1000
Message-ID: <W2w%8.43031$Hj3.129649@newsfeeds.bigpond.com>

Hi Norman,

Hee Hee, I love crossed wires, especially when they're live !!

In your example, you didn't specify the keep option. Therefore by default, it only deallocates the blocks above initial/minextents. You must specify the keep option to deallocate data below the initial/minextents value.

That's why I mentioned the keep option to the original poster, otherwise yes, nothing is deallocated.

Cheers

Richard

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70269794A_at_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 - 06:26:57 CDT