Database Administration (MOSC)

MOSC Banner

shrinking command

edited Jan 21, 2010 6:45AM in Database Administration (MOSC) 2 commentsAnswered ✓
 In using the shrinking command, do I have to enable row movement?
What about when shrinking just and index?


What if I execute the shrink command without enabling row movement?  When OEM suggests to shrink an object and I choose to look at the sql it will execute it does not issue the row movement command yet I see in other documentation the trivial "Don't forget to enable row movement first"?  Who is right?

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