Database Administration (MOSC)

MOSC Banner

what is the best way to shrink the space in such of huge lob segement?

edited Jan 26, 2011 4:33PM in Database Administration (MOSC) 2 commentsAnswered

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 (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center