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 42 43 44 45 46 47 48 49 50
|
CREATE TABLE MaTable
(
COMMUT VARCHAR2(4) NOT NULL,
DATDEB VARCHAR2(10) NOT NULL,
colonne1 VARCHAR2(4) ,
colonne2 VARCHAR2(4),
colonne3 ...
)
TABLESPACE TAB_DRLD_DB_XL
NOLOGGING
PARTITION BY RANGE (DATDEB)
SUBPARTITION BY HASH (COMMUT)
(
PARTITION P_CDR_20051223 VALUES LESS THAN ('2005/12/24')
NOLOGGING
TABLESPACE TAB_DB_P16_L
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
SUBPARTITIONS 4 STORE IN (TAB_DB_P16_L,TAB_DB_P16_L,TAB_DB_P16_L,TAB_DB_P16_L),
PARTITION P_CDR_20051224 VALUES LESS THAN ('2005/12/25')
NOLOGGING
TABLESPACE TAB_DB_P17_L
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
SUBPARTITIONS 4 STORE IN (TAB_DB_P17_L,TAB_DB_P17_L,TAB_DB_P17_L,TAB_DB_P17_L),
PARTITION P_CDR_20051225 VALUES LESS THAN ('2005/12/26')
NOLOGGING
TABLESPACE TAB_DB_P18_L
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
SUBPARTITIONS 4 STORE IN (TAB_DB_P18_L,TAB_DB_P18_L,TAB_DB_P18_L,TAB_DB_P18_L),
....
....
etc... pour 50 partitions |
Partager