Home
Trouble shooting
 

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.