ORA-01691: unable to extend lob segment
ORA-01691: unable to extend lob segment sss.ggg by nnn in tablespace ttt.
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.
- 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: Brian Cryer 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.