Re: Oracle dbf problem

Hi Norman,

I love it when you bark (and growl and make that high pitched squeally noise :)

Yes, deallocate unused gets rid of unused blocks above the HWM. That's the issue that Pauline is facing, having created a table way way too big for the expected size of data and now wanting to free the space back to the tablespace.

Pauline, if you're still there, note you can deallocate used but keep some of the blocks above the HWM (if there is still some modest growth expected). If you can deallocate to an extent boundary, that would be good too.

Cheers

Richard

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702696EB1_at_lnewton.leeds.lfs.co.uk...
> Hi Richard,
>
> I thought that 'deallocate unused' only deallocated space ABOVE the high
> water mark, and not just unused space.
> Am I barking ?
>
> 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
> -------------------------------------
>
>
> -----Original Message-----
> From: Richard Foote [mailto:richard.foote_at_bigpond.com]
> Posted At: Wednesday, July 24, 2002 9:48 AM
> Posted To: server
> Conversation: Oracle dbf problem
> Subject: Re: Oracle dbf problem
>
>
> Hi Pauline,
>
> That's great, glad I could help :)
>
> Note as I mentioned previously that de-allocating the unwanted storage
> with
> the deallocate unused option might be the way to go.
>
> Cheers
>
> Richard
>
>
Received on Wed Jul 24 2002 - 04:19:43 CDT