Database Tuning (MOSC)

MOSC Banner

dbms_redefintion vs. table shrink

edited Feb 1, 2010 9:04PM in Database Tuning (MOSC) 10 commentsAnswered
 For un-framgment segment and adjust HWM, we can use dbms_redefinition package or "alter table shrink".

As far as I can read, the restriction for above approachs are about the same.

Use dbms_redefinition is little bit more complicated than use "alter table shrink".

However "alter table shrink" need a table-level lock, even for a very short time.

Can anyone tell me which approach give us more benifit?

Thanks,

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