ORA-01693: max # extents (120) reached in lob segment

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
from dba_segments
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.

Regards,

Emad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s