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

Thread: Move a number of tables in a tablespace

  1. #1
    Join Date
    Jan 2006
    Posts
    21

    Move a number of tables in a tablespace

    Planning to move more than 200 tables in an existing tablespaceTS_big. Will the command like below looping thru all tables work:

    alter table tab_name move tablesspace TS_big

    Only doubt I have it is an EXISTING tablespace where we want to consolidate all tables.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hmm when some of us is trying to distribute tables across several tablespaces and you are trying to put everything in the same tablespace, interesting

    Just rememebr rebuild all your 200 tables indexes after move your tables

  3. #3
    Join Date
    Jan 2006
    Posts
    21
    I am trying to move all tablespaces of all partitions of A TABLE in a tablespace. I have 200 tablespsaces per TABLE for last 5 years historical data. I am trying to see what problems I may have in my plans.

    So, probs I see:

    Target tablepsace should be big - I have big datafiles with autoextent turned on, this should solve this. No need to calculate totla size of TS etc.
    Indexes- Not sure how to move them as they are in seperate tablespace, alsoe moving them will validate them automatically?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    alter index xxx rebuild tablespace yyy;

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