DROP MATERIALIZED VIEW LOG ON ; CREATE MATERIALIZED VIEW LOG ON 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