RE: Mystery "unable to extend" error

From: Allen, Brandon <>
Date: Fri, 30 May 2008 14:27:39 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450BDA5A64@NT15.oneneck.corp>

I'm not sure about that error, but if that 599124 figure is in blocks and you have 8k blocks, that's a 4.5GB extent it's trying to grab and you've only got 2.5GB free. Also, remember an extent must be contiguous so you could have lots of free space, but just not in large enough contiguous chunks. You can check the size of your free extents with the following query:  

select bytes, count(*) from dba_free_space where tablespace_name = 'USER_LOB' group by bytes;  


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Fri May 30 2008 - 16:27:39 CDT

Original text of this message