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.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.