Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to move special objects to another tablespace??

ScottZhengJun 20 2006 — edited Jun 22 2006

Hi all,
It is easy to move normal tables/indexes to another tablespace.

But how to move special objects(IOT,LOBINDEX,LOBSEGMENT,NESTED TABLE) to another tablespace??
please see below's object types:

select owner,segment_type,count(*) 
from dba_segments
where tablespace_name='EXAMPLE'
group by owner,segment_type;

OWNER                          SEGMENT_TYPE         COUNT(*)
------------------------------ ------------------ ----------
HR                             INDEX                       1
IX                             INDEX                       8
IX                             TABLE                       2  <----IOT tables
OE                             LOBINDEX                    1
OE                             LOBSEGMENT                  1
PM                             LOBINDEX                   17
PM                             LOBSEGMENT                 17
PM                             NESTED TABLE                1
SH                             INDEX                       2
SH                             LOBINDEX                    2
SH                             LOBSEGMENT                  2

-------------

Any example will be appreciated!!
Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2006
Added on Jun 20 2006
10 comments
14,535 views