Reclaim space of deleted lob datatype
When we simply delete some rows from a table having multiple lob datatype columns the no space released from the data file.
To reclaim space of delete lob datatype columns we need to use shrink as follows-
select 'alter table TABLE_NAME modify lob ('||column_name||') (SHRINK SPACE);' from user_tab_columns
where table_name='TABLE_NAME' and data_type='BLOB';
Put your table name on above query and it will generate a script to shrink space occupied by lob segment.
To reclaim space of delete lob datatype columns we need to use shrink as follows-
select 'alter table TABLE_NAME modify lob ('||column_name||') (SHRINK SPACE);' from user_tab_columns
where table_name='TABLE_NAME' and data_type='BLOB';
Put your table name on above query and it will generate a script to shrink space occupied by lob segment.
Comments
Post a Comment