RE: Mystery "unable to extend" error
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <janine@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 May 2008 14:27:39 -0700
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:
