How To Move Lobindex, Lobsegment, Iot-top(index) To Another Tablespace?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How To Move Lobindex, Lobsegment, Iot-top(index) To Another Tablespace?

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29

    How To Move Lobindex, Lobsegment, Iot-top(index) To Another Tablespace?

    Dear All,

    I have a tablespace, which is dictionary managed. Now, I need to move all the objects in that tablespace to a newly created locally managed (uniform) tablespace. I found that in the old tablespace, there are objects with type LobIndex, LobSegment, and IOT-Top Indexes. According to my knowledge, the LobIndex and LogSegment were created under the domain index. And the IOT-TOP indexes were created under IOT tables. Since those objects are not tables, do you know how I can move them to another tablespace? Thanks.

    -- Chris

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: How To Move Lobindex, Lobsegment, Iot-top(index) To Another Tablespace?

    Originally posted by cleegt
    Dear All,
    Since those objects are not tables, do you know how I can move them to another tablespace? Thanks.

    -- Chris
    Code:
    ALTER TABLE table_name MOVE LOB (lob_column) STORE AS (TABLESPACE tablespace_name);
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    May 2001
    Posts
    736

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