SQL> create materialized view log on dept;

Materialized view log created.

SQL> create materialized view mv_dept
  2  refresh fast on commit
  3  as select * from dept;

Materialized view created.

SQL> create table log_dept (deptno number, datum date);

Table created.

SQL> create or replace trigger trg_mv_dept
  2    after insert or update on mv_dept
  3    for each row
  4  begin
  5    insert into log_dept
  6      (deptno, datum)
  7       values
  8      (:new.deptno, sysdate);
  9  end;
 10  /

Trigger created.

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NY
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> insert into dept (deptno, dname, loc)
  2    values (80, 'Test 1', 'Some location');

1 row created.

SQL> update dept set
  2    loc = 'New York'
  3  where deptno = 10;

1 row updated.

SQL> commit;

Commit complete.

SQL> select * from log_dept;

    DEPTNO DATUM
---------- -------------------
        80 03.09.2008 15:40:26
        10 03.09.2008 15:40:26

SQL> insert into dept (deptno, dname, loc)
  2    values (85, 'CSI', 'Miami');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from log_dept;

    DEPTNO DATUM
---------- -------------------
        80 03.09.2008 15:40:26
        10 03.09.2008 15:40:26
        85 03.09.2008 15:41:39

SQL>