Here we are presenting ways to move/rebuild LOB segment First take the initial size of the LOB segment SELECT table_name, column_name, segment_name, a.bytes FROM dba_segments a JOIN dba_lobs b USING (owner, segment_name) WHERE b.table_name = ‘TABLE_NAME’; More queries can found at How to find space usage of lob segments in Oracle database Suppose you know the lob segment name and you want to know which … Continue reading How to move LOB segment to another tablespace »