ORA-01691: unable to extend lob segment

Caused By : Exception java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERS
java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERSat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

….

..
.

 I am seeing this ORA-01691 error and my database is hanging:

Caused By : Exception java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERS
java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERS

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

alter tablespace
   USERS
add datafile
   ‘/u01/../…/ /xxx.dbf
size 1024M AUTOEXTENT ON NEXT 1024M MAXSIZE 32767M;

Hits: 7

Leave a Reply

Your email address will not be published. Required fields are marked *