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

Thread: alter index move?

Hybrid View

  1. 11-09-2006, 03:34 PM #1
    gaegoori
    gaegoori is offline Member
    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
    Reply With Quote Reply With Quote
  2. 11-09-2006, 03:44 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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
    Reply With Quote Reply With Quote
  3. 11-10-2006, 06:07 AM #3
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    530 indexes- that will be slow. Consider using NOLOGGING and PARALLEL clauses
    Reply With Quote Reply With Quote
  4. 11-10-2006, 08:22 AM #4
    mike9
    mike9 is offline Advisor
    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 08:25 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width