迁移索引到新的表空间

----------------------------------
5.迁移索引到新的表空间
----------------------------------


--新建测试环境
create tablespace test
datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\test01.DBF'
size 500m
autoextend on
next 100m maxsize unlimited
extent management local autoallocate
segment   space management auto;


conn scott/tiger




create table scott.emp01 
as
select * from scott.emp;






create index index01 on scott.emp01(ename) ;


*************第一步：迁移索引到别的表空间




--查询表的索引以及对应的表空间


col index_name for a10
col tablespace_name for a10
select index_name,table_name,status,tablespace_name
from user_indexes
where table_name='EMP01';