DROP MATERIALIZED VIEW LOG ON ADR.HL7_TRANSACTION_LOG;
CREATE MATERIALIZED VIEW LOG ON ADR.HL7_TRANSACTION_LOG
TABLESPACE M_DATA_01
PCTUSED    0
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             4M
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOCACHE
LOGGING
NOPARALLEL
WITH ROWID, PRIMARY KEY, SEQUENCE (MESSAGE_TRANSMISSION_TYPE_ID,RECORD_CREATED_DATE,STD_INSTITUTION_ID,TRANSMISSION_DATE)
INCLUDING NEW VALUES;
