索引组织表(三)

2014-11-24 17:08:25 · 作者: · 浏览: 3
ns获得分区名在对每个分区进行move
alter table employees move online;
alter table employees move partition part1;

查看索引组织表信息:
select a.table_name,
a.index_name,
a.index_type,
a.pct_threshold,
nvl(column_name, 'NONE') include_column
from user_indexes a
join user_tab_columns b
on (a.table_name = b.table_name)
and (a.include_column = b.column_id)
where index_type = 'IOT - TOP';