Technical data

Partitioning Recommendations for Oracle Utilities Meter Data Management D-7

);

CREATE UNIQUE INDEX D1T301P0 ON D1_MSRMT_LOG_PARM

(

MEASR_COMP_ID, MSRMT_DTTM, SEQNO, PARM_SEQ

) INDEX TABLESPACE <Tablespace_Name> local COMPRESS 1;

ALTER TABLE D1_MSRMT_LOG_PARM ADD CONSTRAINT D1T301P0 PRIMARY KEY

(MEASR_COMP_ID, MSRMT_DTTM, SEQNO, PARM_SEQ) USING INDEX TABLESPACE

<Tablespace_Name>;

D1_INIT_MSRMT_DATA

CREATE TABLE D1_INIT_MSRMT_DATA

(

INIT_MSRMT_DATA_ID CHAR(14 BYTE) NOT NULL ENABLE,

MEASR_COMP_ID CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,

D1_FROM_DTTM DATE,

D1_TO_DTTM DATE,

DATA_SRC_FLG CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE,

TIME_ZONE_CD CHAR(10 BYTE) DEFAULT ' ' NOT NULL ENABLE,

BUS_OBJ_CD CHAR(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,

BO_STATUS_CD CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,

BO_STATUS_REASON_CD VARCHAR2(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,

STATUS_UPD_DTTM DATE NOT NULL ENABLE,

CRE_DTTM DATE NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

IMD_EXT_ID VARCHAR2(120 BYTE),

IMD_BO_DATA_AREA CLOB,

PREVEE_BO_DATA_AREA CLOB,

POSTVEE_BO_DATA_AREA CLOB,

TRACE_BO_DATA_AREA CLOB,

RAW_BO_DATA_AREA CLOB

) TABLESPACE <Tablespace_Name>

ENABLE ROW MOVEMENT

LOB (PREVEE_BO_DATA_AREA)