I read in one document, for defregmenting a table we can use below steps.
1. alter table move
Can any one please expalin what is the difference between above 3..?
did you read the docs to see what they do? - they all do very different things
also I bet you do not have fragmentation
In the doc, they listed only these 3 but didnt explained.
If you get a chance then can you please explain.
Those are not "steps" but "alternatives" to defrag a table.
Originally Posted by tmgsam
First one will defrag by moving the segment.
Second one will defrag by exporting and importing the segment.
Third one will defrag by creating a new table.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Thanks for the note.
I agree, these three are the alternatives for doing defragmentation.
But for same purpose why we require three alternatives..?
If we have more than one then each should be having its own advantages and disadvantages.
I surfed, but didnt get proper adv and disv...!
Click Here to Expand Forum to Full Width