DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: lots of chaining

  1. #11
    Join Date
    Sep 2000
    Posts
    96
    Isn't it true that alter table move only works with index-organized tables?

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    MOVE TABLE works with all tables EXCEPT IOT's.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #13
    Join Date
    Nov 2000
    Posts
    344
    JDoyle,

    If your table is not very large and you are on 8i, I think the 'alter table move' option is better.

    Your method is good and it does work. Prior to 8i, there was
    no 'alter move' command, so the only options were your suggestion and exp/imp.

    The only problem with your suggestion is that it can put a lot of blocks on freelists, which basically means that now your table is somewhat fragmented (which is not as bad as chained rows, I don't think).

    But if your table is very big, you might not have the time to do an 'alter move', then rebuild all of the indexes, then re-analyze your tables, so that's when your suggestion can be handy.

    -John



  4. #14
    Join Date
    Nov 2000
    Posts
    344
    Oh yeah -

    2 more steps you might want to include in JDoyle's method :

    Disable any FK constraints and triggers on your table
    (if there are any) and then enable them again afterwards!

    :-)

    -John

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