1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE TABLE t_Historique
( NUM_ETA NUMBER(8),
NUM_ASS NUMBER(6),
NUM_CLI NUMBER(6),
NUM_AFF NUMBER(2),
COD_ACT VARCHAR2(5),
COD_BNF VARCHAR2(5),
NUM_SIN NUMBER(8),
NUM_GAR NUMBER(3),
COD_ART VARCHAR2(5),
COD_TAB VARCHAR2(2) not null,
COD_EVT VARCHAR2(5) not null,
COD_USR VARCHAR2(15) not null,
COD_COU VARCHAR2(10),
DAT_HST DATE not null,
LIB_IMGAVT VARCHAR2(60),
LIB_IMGAPR VARCHAR2(60),
COD_DOC VARCHAR2(5) )
PARTITION BY RANGE ( NUM_CLI)
( PARTITION num_cli_q1 VALUES LESS THAN ( 100000)
TABLESPACE INDEX_3)
ENABLE ROW MOVEMENT |
Partager