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

Thread: Relocate Index

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Hi all,
    The dba before me created an index on USERS table and put it on USERS tablespace. I believe the index created should be in INDEX TABLESPACE.
    How can move or relocate the index to INDEX tablespace?

    Thank you
    Ablakios
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Jan 2002
    Posts
    4
    Type:

    alter index index_name rebuild tablespace new_tablespacename

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Thank you for the prompt response.
    Cheers
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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