Fregmentation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Fregmentation

  1. #1
    Join Date
    Feb 2009
    Posts
    49

    Fregmentation

    Hi,

    I read in one document, for defregmenting a table we can use below steps.
    1. alter table move
    2. exp/imp
    3. CTAS

    Can any one please expalin what is the difference between above 3..?

    Regards,
    Mas

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    did you read the docs to see what they do? - they all do very different things

    also I bet you do not have fragmentation

  3. #3
    Join Date
    Feb 2009
    Posts
    49
    In the doc, they listed only these 3 but didnt explained.

    If you get a chance then can you please explain.

    Regards,
    MAs

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by tmgsam View Post
    I read in one document, for defregmenting a table we can use below steps.
    1. alter table move
    2. exp/imp
    3. CTAS

    Can any one please expalin what is the difference between above 3..?
    Those are not "steps" but "alternatives" to defrag a table.
    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.

  5. #5
    Join Date
    Feb 2009
    Posts
    49
    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...!

    Regards,
    Mas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width