1 0 0 BEGIN END; CREATE UNIQUE BITMAP INDEX ; ON CLUSTER 0 REVERSE INVISIBLE TABLESPACE " " 0 ON ( ." " DESC , ) REVERSE FROM "T " , WHERE ." "= ." " AND 1 "T " 0 ON ( " " DESC , ) 0 COMPRESS INDEXTYPE IS PARAMETERS (' ') GLOBAL PARTITION BY RANGE RANGE HASH LOCAL ( PARTITION " " VALUES LESS THAN ( ) TABLESPACE " " PARAMETERS (' ') ( SUBPARTITION " " TABLESPACE " " , ) , ) ALTER INDEX MODIFY PARTITION " MODIFY SUBPARTITION " " UNUSABLE ; DBMS_STATS.SET_INDEX_STATS(OWNNAME=>' ', INDNAME=>' ', NUMROWS=> , NUMLBLKS=> , NUMDIST=> , AVGLBLK=> , AVGDBLK=> , CLSTFCT=> ) ;