分区索引truncate某个分区,分区索引不失效

<pre name="code" class="sql"><pre name="code" class="sql">SQL> select index_name,partition_name,user_stats,status from dba_ind_partitions where index_name='IDX1_T_PM_RANKINFO' and partition_name='RANKINFO_20140101';

INDEX_NAME		       PARTITION_NAME		      USE STATUS
------------------------------ ------------------------------ --- --------
IDX1_T_PM_RANKINFO	       RANKINFO_20140101	             NO  USABLE

STATUS :USABLE 表示可用


SQL> select index_name,index_type,partitioned,status from dba_indexes where index_name='IDX1_T_PM_RANKINFO';

INDEX_NAME		       INDEX_TYPE		   PAR STATUS
------------------------------ --------------------------- --- --------
IDX1_T_PM_RANKINFO	       NORMAL			   YES  N/A



STATUS: Indicates whether a nonpartitioned index is VALID or UNUSABLE

create index IDX1_T_PM_RANKINFO on T_PM_RANKINFO (MGR_CODE) local;



SQL>  expl