Technical data

D-10 Oracle Utilities Meter Data Management Database Administrator’s Guide
BO_STATUS_REASON_CD VARCHAR2(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,
CHAR_TYPE_CD CHAR(8 BYTE) DEFAULT ' ' NOT NULL ENABLE,
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,
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,
DESCRLONG VARCHAR2(4000 BYTE) DEFAULT ' ' NOT NULL ENABLE,
LOG_DTTM DATE NOT NULL ENABLE,
LOG_ENTRY_TYPE_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MESSAGE_CAT_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,
MESSAGE_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,
USER_ID CHAR(8 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 D1T306P0 ON D1_INIT_MSRMT_DATA_LOG
(
INIT_MSRMT_DATA_ID, SEQNO
) TABLESPACE <Tablespace_Name>LOCAL COMPRESS 1;
ALTER TABLE D1_INIT_MSRMT_DATA_LOG ADD CONSTRAINT D1T306P0 PRIMARY KEY
(INIT_MSRMT_DATA_ID, SEQNO) USING INDEX TABLESPACE <Tablespace_Name>;
CREATE INDEX D1T306S1 ON D1_INIT_MSRMT_DATA_LOG
(
CHAR_TYPE_CD, CHAR_VAL_FK1
) TABLESPACE <Tablespace_Name> COMPRESS 1;
CREATE INDEX D1T306S2 ON D1_INIT_MSRMT_DATA_LOG
(
CHAR_TYPE_CD, CHAR_VAL
) TABLESPACE <Tablespace_Name> COMPRESS 1;
D1_INIT_MSRMT_DATA_LOG_PARM
CREATE TABLE D1_INIT_MSRMT_DATA_LOG_PARM
(
INIT_MSRMT_DATA_ID CHAR(14 BYTE),
SEQNO NUMBER(5,0),
PARM_SEQ NUMBER(3,0),
MSG_PARM_VAL VARCHAR2(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,
MSG_PARM_TYP_FLG CHAR(4 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)