move table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: move table

  1. #1
    Join Date
    Mar 2001
    Posts
    78

    Question

    I have a table called EMP which is in the EMP_TBS tablespace. The table EMP is fragmented so I want to use the alter table move command to fix the fragmentation issue. I do not want to move the table into another tablespace, I want it to remain in the same tablespace. ButI am not sure if I isuue "alter table EMP move" will work if the table that I am moving is going to remain in the same old tablespace.
    Any thouhghts on that?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yup, it will work.
    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. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yea it works as long as you have enough big free chunk extent, alter table move locks the table though

  4. #4
    Join Date
    Mar 2001
    Posts
    78
    So assuming the table EMP is using its 45 extents, will the alter table move command make all the extents one?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No. Without specifying storage parameters, ALTER TABLE ... MOVE will use the existing parameters and you will probably end up with the exact same number of extents you had before. Change the command to ALTER TABLE... MOVE STORAGE (initial xM next xM ...) to resize it.
    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."

  6. #6
    Join Date
    Mar 2001
    Posts
    78
    thanks

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