Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-01691: unable to extend lob segment

Christy H.Dec 24 2011 — edited Dec 25 2011

Hello,

I am getting the following code:

java.sql.SQLException: ORA-01691: unable to extend lob segment 
MI.SYS_LOB0000082688C00020$$ by 128 in tablespace SYSTEM

I googled and found this thread helpful 1110490

alter database datafile '<DATA_FILE_NAME>' autoextend on maxsize unlimited;
and you can also do the same with the temp tablespace.

This is my data files. I am right? If yes then may I change all 4 of the following? Furthermore, where I can find the temp tablespace

select name from v$datafile
/usr/lib/oracle/xe/oradata/XE/system.dbf
/usr/lib/oracle/xe/oradata/XE/undo.dbf
/usr/lib/oracle/xe/oradata/XE/sysaux.dbf
/usr/lib/oracle/xe/oradata/XE/users.dbf

Thanks in anticipation

Edited by: Christy H. on Dec 24, 2011 11:30 AM

This post has been answered by sb92075 on Dec 24 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 22 2012

Added on Dec 24 2011

#general-database-discussions

8 comments

5,815 views