create index IDX_T_GPS_CPH_local on T_GPS (CPH) local;
create index IDX_T_GPS_SJ_local on T_GPS (SJ) local;
select * from dba_ind_partitions where index_owner =‘GPSV4_HIS‘ order by partition_name
从结果推看,建立Local索引时如果不指定分区,则每个分区上都建立一个。
-----------
http://blog.csdn.net/jackpk/article/details/3788445
创建查看和浅析LOCAL INDEX和GLOBAL INDEX