LMT problems - Progress ....

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 30 Jul 2002 12:58:19 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026FAC99@lnewton.leeds.lfs.co.uk>

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


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

Received on Tue Jul 30 2002 - 06:58:19 CDT