what is the best way to shrink the space in such of huge lob segement?
We are using 10.2.0.3 on Linux
We are trying
shrink a table containing LOB segments.
We use the following command:
alter table <TABLE_NAME> enable row movement;
alter table <TABLE_NAME> shrink space cascade;
alter table <TABLE_NAME> disable row movement;
Q1: what is the best way to shrink the space in such of huge lob segement?
Q2: How long will it take approximatly?
Q3:Is there any performance issue when doing the shrink?
Q4:Is there any corruption risk when doing the shrink?
I have checked all the docs below
How to determine the actual size of the LOB segments and how to free the deleted/unused space above/below the HWM ( |