RE: Mystery "unable to extend" error

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;
 
Regards,
Brandon

 




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.

Other related posts: