How to move 3 indexes of a place for another one? without using export or recreate???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to move 3 indexes of a place for another one? without using export or recreate???

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Question

    How to move 3 indexes of a tablespace for another one? without using export or recreate????


  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    hhbrazil,
    ALTER INDEX with the rebuild clause placing the "rebuilt" index into a new tablespace with new allocation parameters...

  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Talking

    Question , when I use rebuild cluasule , this index are move to a new tblspc??

  4. #4
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    hhbrazil,

    The index WILL move if you specify a different tablespace in the parameters of the rebuild clause...

  5. #5
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Wink

    OK.

    thank you for its attention, they are little the people that only help the other ones for the pleasure of helping like you..
    your attention.


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