1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
CREATE UNIQUE INDEX IFTXAFDSOC_PK ON IFTMAFDSOC
(CTSOLE, DFARR, COCLTC, COVALI, CESIT1,
CESIT2, CESIT3, CESIT4, CESIT5, CESIT6,
CESIT7, CESIT8, CESITS, CORTIT)
TABLESPACE IFTXA1
INITRANS 2
MAXTRANS 255
LOCAL (
PARTITION P_20080321
NOLOGGING
TABLESPACE IFTXA1
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P_20080321_Q VALUES ('Q') TABLESPACE IFTXA1 ),
PARTITION P_20080325
NOLOGGING
TABLESPACE IFTXA1
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P_20080325_Q VALUES ('Q') TABLESPACE IFTXA1 ),
PARTITION P_20080326
NOLOGGING
TABLESPACE IFTXA1
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P_20080326_Q VALUES ('Q') TABLESPACE IFTXA1 )
)
NOPARALLEL; |
Partager