create table tong(id int); create materialized view log on tong NOLOGGING PCTFREE 1 PCTUSED 99 WITH SEQUENCE,ROWID( id ) INCLUDING NEW VALUES; INSERT INTO tong VALUES (1); UPDATE tong SET ID = 2 WHERE ID = 1; DELETE FROM tong WHERE ID = 2; commit; select * from MLOG$_tong; ID M_ROW$$ SEQUENCE$$ SNAPTIME$$ DMLTYPE$$ OLD_NEW$$ CHANGE_VECTOR$$ ---------- -------------------------------------------------------------------------------- ---------- ----------- --------- --------- -------------------------------------------------------------------------------- 1 AAASTKAAEAADxROAAA 1 01.01.4000 I N FE 1 AAASTKAAEAADxROAAA 2 01.01.4000 U U 02 2 AAASTKAAEAADxROAAA 3 01.01.4000 U N 02 2 AAASTKAAEAADxROAAA 4 01.01.4000 D O 00