Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    41

    Unanswered: Moving Indexes - ???

    Hi all,

    At the moment, we have a "rule" that tables and indexes should reside in different tablespaces. I know
    this is an "old" rule before the time of the SAN but we want to keep this same rule.

    Now we inherited an install where tables and indexes are on one single tablespace and we want to move
    the indexes into a separate tablespace.

    We've move the "normal" indexes and currently still left with indexes that are LOB, IOT - TOP and
    FUNCTION-BASED NORMAL.

    I know we can move the LOB and FUNCTION-BASED NORMAL but there is a huge arguments amongts our DBAs
    that we cannot move IOT - TOP because they contain actual data? May I have the opinions of the gurus
    please whether it is possible or not to move IOT - TOP indexes and whether they really contain data
    or just plain indexes?

    Any response will be very much appreciated.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Indexed Organized Tables(IOT) are a hybrid of data and the index and under your rules should be left in the data tablespace. IMHO
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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