alter index move?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: alter index move?

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    alter index move?

    Hi,

    I would like to move 530 indexes from tablespace 1 to tablespace 2. Is there a move command to move indexes out like alter table move command?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Cool


    Try:
    PHP Code:
    ALTER INDEX MyIndex REBUILD TABLESPACE MyTablespace

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    530 indexes- that will be slow. Consider using NOLOGGING and PARALLEL clauses

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    It would probably be faster to run several rebuild scripts in parallel then to run on rebuil in parallel.

    Also before using nologging I would check if it fits in your recovery concept.
    Last edited by mike9; 11-10-2006 at 07:25 AM.

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