Technical data

Partitioning Recommendations for Oracle Utilities Meter Data Management D-9
CHAR_VAL_FK2 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CHAR_VAL_FK3 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CHAR_VAL_FK4 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CHAR_VAL_FK5 VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,
SRCH_CHAR_VAL VARCHAR2(50 BYTE) DEFAULT ' ' NOT NULL ENABLE,
VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE)
TABLESPACE <Tablespace_Name>
ENABLE ROW MOVEMENT
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));
CREATE UNIQUE INDEX D1T305P0 ON D1_INIT_MSRMT_DATA_CHAR
(
INIT_MSRMT_DATA_ID, CHAR_TYPE_CD, SEQ_NUM
) TABLESPACE <Tablespace_Name> LOCAL COMPRESS 1;
ALTER TABLE D1_INIT_MSRMT_DATA_CHAR ADD CONSTRAINT D1T305P0 PRIMARY
KEY (INIT_MSRMT_DATA_ID, CHAR_TYPE_CD, SEQ_NUM) USING INDEX
TABLESPACE <Tablespace_Name>;
CREATE INDEX D1T305S1 ON D1_INIT_MSRMT_DATA_CHAR
(
SRCH_CHAR_VAL
) TABLESPACE <Tablespace_Name> COMPRESS 1;
D1_INIT_MSRMT_DATA_K
CREATE TABLE D1_INIT_MSRMT_DATA_K
(
INIT_MSRMT_DATA_ID CHAR(14 BYTE),
ENV_ID NUMBER(6,0) NOT NULL ENABLE,
CONSTRAINT D1T314P0 PRIMARY KEY (INIT_MSRMT_DATA_ID, ENV_ID) ENABLE
)
ORGANIZATION INDEX TABLESPACE <Tablespace_Name>
ENABLE ROW MOVEMENT
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)) compress 1;
D1_INIT_MSRMT_DATA_LOG
CREATE TABLE D1_INIT_MSRMT_DATA_LOG
(
INIT_MSRMT_DATA_ID CHAR(14 BYTE),
SEQNO NUMBER(5,0),
BO_STATUS_CD CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,