MODIFYING THE STORAGE FOR LOB SEGMENTS

This morning i got an alarm for a lob segment which was reaching its max extents , i checked for the available free space in the tablespace where the lob segment was available  , the tablespace was filled by only 50%.
So the next solution was to modify/increase the MAX EXTENTS storage clause for the lob segment .

Here is how i did it .

1) CHECKING THE LOB SEGMENT DETAILS  : 

select tablespace_name,segment_type,max_extents,next_extent,extents from dba_segments where segment_name='SYS_LOB0000007907C00009$$';

2) IDENTIFYING THE TABLE NAME AND COLUMN NAME : 

select owner||'.'||table_name "TABLE", column_name, segment_name from all_lobs where segment_name='SYS_LOB0000007907C00009$$';

3) MODIFYING THE STORAGE CLAUSE:

alter table owner.tablename modify lob (COLUM_NAME) (storage (maxextents unlimited ) );