oracle索引迁移，释放磁盘空间(三)
tafile 'D:\ORACLE\ORADATA\INNETDB\USERINDEX10.DBF' offline;
alter database datafile 'D:\ORACLE\ORADATA\INNETDB\USERINDEX11.DBF' offline;
alter database datafile 'D:\ORACLE\ORADATA\INNETDB\USERINDEX12.DBF' offline;
6.删除USERINDEX表空间及相关联文件，再观察磁盘是否是否空间
drop tablespace USERINDEX
including contents and datafiles cascade constraints;
7.编译oracle相关服务是否有存储错误，用gbos账号登陆 是否能正常查询表，
启动相关服务。 www.2cto.com
注意：分别查看表索引对应的数据文件
select TABLE_NAME,SEGMENT_NAME,TABLESPACE_NAME,INDEX_NAME from dba_lobs where OWNER='GBOS';
select header_file,segment_name,tablespace_name,header_block from dba_segments
where segment_name='SYS_C0036848';
select INDEX_NAME,TABLE_NAME from dba_indexes where owner='GBOS' ;
select header_file,segment_name,tablespace_name,header_block from dba_segments
where segment_name='T_O_MENUSET_PK';