-
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
-
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"
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|