PARTITION BY RANGE RANGE HASH LIST RANGE INTERVAL ( ) STORE IN ( , ) PARTITION BY LIST LIST HASH LIST RANGE PARTITION BY HASH HASH PARTITION BY SYSTEM SYSTEM PARTITION BY REFERENCE (" ") REFERENCE ( ) Y , ( SUBPARTITION " " VALUES ( ) LIST 1 VALUES LESS THAN ( ) RANGE 1 HASH 1 , ) SUBPARTITION BY HASH HASH SUBPARTITION BY LIST LIST SUBPARTITION BY RANGE RANGE SUBPARTITIONS SUBPARTITION TEMPLATE PARTITION " " VALUES LESS THAN ( ) VALUES ( ) DBMS_STATS.SET_TABLE_STATS(OWNNAME=>' ', TABNAME=>' ', PARTNAME=>' ', NUMROWS=> , NUMBLKS=> , AVGRLEN=> ) ; DBMS_STATS.SET_INDEX_STATS(OWNNAME=>' ', INDNAME=>' ', PARTNAME=>' ', NUMROWS=> , NUMLBLKS=> , NUMDIST=> , AVGLBLK=> , AVGDBLK=> , CLSTFCT=> ) ;