Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212

    Unanswered: how to change index tablespace?

    Guys,
    how can I change index tablespace?

    I have index idx_customer_id in tablespace TABTS
    I want to move it to IDXTS, how can I do that? But I don't want to drop and recreate index. Just somehow change tablespace which index is using.

    Thank you for advice.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    look up 'alter index...rebuild tablespace x' in the sql ref. You may also be able to use the online clause in some cases.

    Alan

  3. #3
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    it works, thanx

Posting Permissions

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