Database Administration (MOSC)

MOSC Banner

Reclaiming unused space through alter table shrink..,after mass insertion/deletion from table

edited Dec 9, 2013 3:50AM in Database Administration (MOSC) 10 commentsAnswered
Dear All,

I have found something about table shrink to reclaim unused space , after mass insertion/deletion from table....

So My queries are,

Oracle DB - 11.1.0.6.0 Standard Edition

On Internet, I have found something like below queries to shrink table

  " ALTER TABLE TABLE_NAME SHRINK SPACE COMPACT" 

and after that apply  following command

 " ALTER TABLE TABLE_NAME SHRINK SPACE"

Why we should apply compact query first and then shrink space ? what is the effect of it?

and also to use shrink space, you need to enable row movement.....

What is row movement? and What are the effects on database (performancewise etc...) if row movement is enabled?

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