Oracle dbf problem

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 24 Jul 2002 13:58:02 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702699409@lnewton.leeds.lfs.co.uk>

Hi Richard,

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

>> In your example, you didn't specify the keep option.
True, but up until about 5 minutes ago, I hadn't realised such a beast existed. Mea Culpa.

>> 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.
Sound of penny dropping. (Well hitting the floor actually!)

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

I missed it - sorry. But you did hide it well :o)

I've tried it out on a 64KB uniform extent LMT and it 'just works'.

That's today's first learning experience !

Thanks.

Regards,
Norman.

Thinks : didn't I write a FAQ for Jonathan on this very subject .............

---

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 - 07:58:02 CDT