Technical data

Partitioning Recommendations for Oracle Utilities Meter Data Management D-3
PARTITION P7 VALUES LESS THAN(TO_DATE('15/03/2011 00:00:01','DD/MM/
YYYY HH24:MI:SS'))
);
CREATE UNIQUE INDEX D1T298P0 on D1_MSRMT (MEASR_COMP_ID, MSRMT_DTTM)
TABLESPACE <Tablespace_Name> local COMPRESS 1;
alter table D1_MSRMT ADD CONSTRAINT D1T298P0 PRIMARY
KEY(MEASR_COMP_ID, MSRMT_DTTM) USING INDEX TABLESPACE
<Tablespace_Name> ;
Note: For implementations on Exadata the following D1T298S1 Index is not
required:
CREATE UNIQUE INDEX D1T298S1 on D1_MSRMT (MEASR_COMP_ID, MSRMT_DTTM,
MSRMT_COND_FLG, MSRMT_USE_FLG) TABLESPACE <Tablespace_Name> local
COMPRESS 1;