one of the developers have faced the below error in his application:
ORA-01693: max # extents (120) reached in lob segment SCHEMA1.SYS_LOB0000377024C00009
This error is caused by the LOB segment ran out of database space.
To resolve this:
first, make sure that your tablespace of schema1 is sufficient enough.
Second, use the below query to find out more information about the segment:
select SEGMENT_NAME, SEGMENT_TYPE, MAX_EXTENTS
where segment_name = ‘SYS_LOB0000705396C00006$$’;
Final step: increase the “maxextent” for the lob segment by using the below command:
SQL> ALTER TABLE SCHEMA1.T_INCIDENT_REPORT
MODIFY LOB (ATTACH_DOC) (STORAGE (MAXEXTENTS UNLIMITED));
Remark: “ATTACH_DOC” is the column in the table that is stored in “LOB” format.
Hope This will help.