oracle 分区 不走索引,表进行分区后不走索引

create table T_IM_TRANSFERORDERBILL

(

FID                      VARCHAR2(44) not null,

FCREATORID               VARCHAR2(44),

FCREATETIME              TIMESTAMP(6),

FLASTUPDATEUSERID        VARCHAR2(44),

...

FALTERDATE               TIMESTAMP(6),

FOLDBILLID               VARCHAR2(44),

FOLDBILLSTATUS           NUMBER(10)

)

partition by range (FBIZDATE)

subpartition by hash (FID)

(

partition P1 values less than (TIMESTAMP' 2010-01-01 00:00:00')

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP125 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP126 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP127 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP128 tablespace EAS_D_JINGYA_STANDARD

),

partition P2 values less than (TIMESTAMP' 2011-01-01 00:00:00')

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP129 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP130 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP131 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP132 tablespace EAS_D_JINGYA_STANDARD

),

partition P3 values less than (TIMESTAMP' 2012-01-01 00:00:00')

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP133 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP134 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP135 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP136 tablespace EAS_D_JINGYA_STANDARD

),

partition P4 values less than (TIMESTAMP' 2013-01-01 00:00:00')

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP137 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP138 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP139 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP140 tablespace EAS_D_JINGYA_STANDARD

),

partition P5 values less than (TIMESTAMP' 2014-01-01 00:00:00')

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP141 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP142 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP143 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP144 tablespace EAS_D_JINGYA_STANDARD

),

partition PMAX values less than (MAXVALUE)

tablespace EAS_D_JINGYA_STANDARD

pctfree 10

initrans 1

maxtrans 255

(

subpartition SYS_SUBP145 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP146 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP147 tablespace EAS_D_JINGYA_STANDARD,

subpartition SYS_SUBP148 tablespace EAS_D_JINGYA_STANDARD

)

);