Cry
about...
Oracle Troubleshooting
ORA-01691: unable to extend lob
segment
Symptom:
The error:
ORA-01691: unable to extend lob
segment sss.ggg by nnn in tablespace ttt.
Cause:
While inserting records Oracle needed to
extend a segment but there was insufficient space to
allow it to do so, i.e. the tablespace is full.
Possible Remedies:
Add additional datafiles to the
tablespace.
Extend one or more datafiles in
the tablespace.
Reduce the 'next'
size for the table/segment to be consistent with
the amount of free space available in any of the
datafiles that compose the tablespace.
|