Mystery "unable to extend" error
- From: Janine Sisk <janine@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 May 2008 13:51:47 -0700
This is an old 8.1.7 installation on Linux, which suffers from the "2
GB per file" problem. A file upload started giving "ORA-01691:
unable to extend lob segment" errors so I added another data file to
the tablespace, but inexplicably (to me) the errors continue.
There is now plenty of free space in the tablespace:
Tablespace Name Total Bytes Used
Free %Used
---------------- ------------------ --------------- ----------------
------
USER_LOB 17,112,760,320 14,613,618,688 2,499,141,632 85.4
And yet..
error in `OCILobWrite ()': ORA-01691: unable to extend lob segment
USER.SYS_LOB0000041854C00017$$ by 599124 in tablespace USER_LOB
(where I have replaced the actual user name with USER)
I have never seen this before; adding another data file has always
been the solution in the past. I don't even know where to look
next. Any suggestions?
thanks,
janine
---
Janine Sisk
President/CEO of furfly, LLC
503-693-6407
- Follow-Ups:
- RE: Mystery "unable to extend" error
- From: Allen, Brandon
Other related posts:
- » Mystery "unable to extend" error
- » RE: Mystery "unable to extend" error
- » Re: Mystery "unable to extend" error
- » Re: Mystery "unable to extend" error
- » RE: Mystery "unable to extend" error
- » Re: Mystery "unable to extend" error
- RE: Mystery "unable to extend" error
- From: Allen, Brandon