Database Administration (MOSC)

MOSC Banner

What is the difference in benefits of SHRINK SPACE and MOVE commands

I understand that SHRINK SPACE moves the HWM down while MOVE doesn't, but on the other hand, MOVE will build on newly allocated blocks and removes row chaining which is not done by SHRINK SPACE that uses existing blocks. Also, in SHRINK the rowids in indexes are updated but in MOVE we have to rebuild the indexes as they become unusable. Also, MOVE can be used to change the storage parameters, but want to know what are the benefits of using either one or both of them to improve the performance.

Thanks,

Chalam

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