----------------------------------
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';
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';