Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LMT problems - Progress ....
Is this 9i?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7026FAC99_at_lnewton.leeds.lfs.co.uk...Received on Tue Jul 30 2002 - 07:31:39 CDT
> I have worked out a possible reason for the probloem.
>
>
> The table in question is in a database with 8K block size and the
> tablespace is LMT 64KB uniform size.
>
> If I deallocate with keep > number of free blocks above HWM I get
> Ora-00600.
> If I deallocate <= free blocks above HWM then it works AND any further
> attampt to deallocate with a size > free blocks above HWM gives
> ORA-03230 Segment only has 3 unused blocks above HWM.
>
> So, I think I should be getting the 3230 error but something is wrong
> internally and I get the 600 instead.
>
> The workaround at the moment is to 'keep 1K' which is a figure which is
> lower (hopefully) than the amount of space above HWM that is unused.
>
> 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
> -------------------------------------
>