Return
-
Title
ORA-01691: Unable to extend lob segment when attaching a file to a CSR -
Description
Getting error ORA-01691: unable to extend lob segment STAT.SYS_LOB0000076123C00008$$ by 8192 in tablespace STLOB when adding an Oracle patch zip file as an attachment to a CSR. The file size shows as 48806KB and Maximum file size for CSR attachment system parameter is set to 52428800. This file has previously successfully been attached to a different CSR. -
Cause
The tablespace STLOB is full. -
Resolution
Solution:1. Your DBA check dba_data_files, dba_tablespaces, v$datafile to see how tablespace XXXXX is build up or used.2. Once you identified the tablespace that has the issue, your DBA should know how to fix the error. For example, by running the statement below:alter tablespace STLOB add datafile '/u01/app/oracle/ . . . /xxx.dbf' size 10G; -
Additional Information
For all Stat versions