戻る
-
タイトル
ORA-01691: Unable to extend lob segment when attaching a file to a CSR -
説明
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. -
原因
The tablespace STLOB is full. -
対策
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; -
追加情報
For all Stat versions