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