Technical data

D-8 Oracle Utilities Meter Data Management Database Administrator’s Guide
PARTITION P2 VALUES LESS THAN(TO_DATE('01/01/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P3 VALUES LESS THAN(TO_DATE('15/01/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P4 VALUES LESS THAN(TO_DATE('01/02/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P5 VALUES LESS THAN(TO_DATE('15/02/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P6 VALUES LESS THAN(TO_DATE('01/03/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P7 VALUES LESS THAN(TO_DATE('15/03/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS')),
PARTITION P8 VALUES LESS THAN (maxvalue)
);
CREATE UNIQUE INDEX D1T304P0 ON D1_INIT_MSRMT_DATA
(
INIT_MSRMT_DATA_ID
) TABLESPACE <Tablespace_Name>
GLOBAL PARTITION BY RANGE (INIT_MSRMT_DATA_ID)
(PARTITION PART1 values less than (12499999999999),
PARTITION PART2 values less than (24999999999999),
PARTITION PART3 values less than (37499999999999),
PARTITION PART4 values less than (49999999999999),
PARTITION PART5 values less than (62499999999999),
PARTITION PART6 values less than (74499999999999),
PARTITION PART7 values less than (87499999999999),
PARTITION PART8 values less than (maxvalue));
ALTER TABLE D1_INIT_MSRMT_DATA ADD CONSTRAINT D1T304P0 PRIMARY KEY
(INIT_MSRMT_DATA_ID) USING INDEX TABLESPACE <Tablespace_Name>;
CREATE INDEX D1T304S1 ON D1_INIT_MSRMT_DATA
( MEASR_COMP_ID
,BO_STATUS_CD
,BUS_OBJ_CD
,D1_TO_DTTM
,D1_FROM_DTTM
) TABLESPACE <Tablespace_Name> LOCAL COMPRESS 1;
CREATE UNIQUE INDEX D1T304S2 ON D1_INIT_MSRMT_DATA
(INIT_MSRMT_DATA_ID,
BO_STATUS_CD,
BUS_OBJ_CD ) TABLESPACE <Tablespace_Name> COMPRESS 1;
CREATE UNIQUE INDEX D1T304S3 ON D1_INIT_MSRMT_DATA
(IMD_EXT_ID,
INIT_MSRMT_DATA_ID
) TABLESPACE <Tablespace_Name> COMPRESS 1;
D1_INIT_MSRMT_DATA_CHAR
CREATE TABLE D1_INIT_MSRMT_DATA_CHAR
(
INIT_MSRMT_DATA_ID CHAR(14 BYTE),
CHAR_TYPE_CD CHAR(8 BYTE),
SEQ_NUM NUMBER(3,0),
CHAR_VAL CHAR(16 BYTE) DEFAULT ' ' NOT NULL ENABLE,
ADHOC_CHAR_VAL VARCHAR2(254 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CHAR_VAL_FK1 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,