
DROP MATERIALIZED VIEW LOG ON EX_DATA1 ;
CREATE MATERIALIZED VIEW LOG ON EX_DATA1 
WITH ROWID 
(
CRDATE, 
CRSEQ, 
DATE1, 
DATE2, 
DATE3, 
D1, 
D2, 
D3, 
D4, 
D5, 
D6, 
D7, 
D8, 
D9, 
D10, 
D11, 
D12, 
D13, 
D14, 
D15, 
D16, 
D17, 
D18, 
D19, 
D20, 
D21, 
D22, 
D23, 
D24, 
D25, 
D26, 
D27, 
D28, 
D29, 
D30, 
KEY1, 
KEY2, 
KEY3, 
KEY4, 
KEY5, 
KEY6, 
KEY7, 
KEY8, 
KEY9, 
KEY10, 
KEY11, 
KEY12, 
KEY13, 
KEY14, 
KEY15, 
KEY16, 
KEY17, 
KEY18, 
KEY19, 
KEY20, 
KEY21, 
KEY22, 
KEY23, 
KEY24, 
KEY25, 
KEY26, 
KEY27, 
KEY28, 
KEY29, 
KEY30
),
SEQUENCE INCLUDING NEW VALUES;

DROP MATERIALIZED VIEW LOG ON EX_DAY ;
CREATE MATERIALIZED VIEW LOG ON EX_DAY WITH ROWID 
(
EX_DATE, 
EX_TERM, 
EX_WEEK, 
EX_YYYY, 
EX_YYYYMM, 
EX_YYYYMMDD
), 
SEQUENCE INCLUDING NEW VALUES;

COMMIT;


EXIT
