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

Thread: moving indexes

  1. #1
    Join Date
    Aug 2002
    Posts
    19

    Question moving indexes

    Hi,

    Is there any command to move indexes from Users tablespace to indx tablespace apart from dropping and re-creating them using Dynamic SQL.

    I'm trying to look for something similar to this command -

    ALTER INDEX MOVE..........??????????


    Regards,
    Soma
    Soma

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    alter index rebuild
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Aug 2002
    Posts
    19
    Thanks and it works..
    Soma

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