Tag Archives: lob index

How to move LOB segment to another tablespace

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’; Now lets take a look at various ways to rebuild the lob 1) Alter table move command If you just want to move the table without impacting LOB Segments,then … Continue reading How to move LOB segment to another tablespace »