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