Don't panic!

 

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.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.