Materialized view

create materialized view mv
  REFRESH COMPLETE [complete refresh replaces old value by new value]
  as select * from test;


execute DBMS_MVIEW.REFRESH( LIST => 'MV', METHOD => 'C' );[C For complete]





create materialized view log on test;

CREATE MATERIALIZED VIEW mv
REFRESH FAST [refresh only changes value]
AS
SELECT * FROM test;

execute DBMS_MVIEW.REFRESH( LIST => 'MV', METHOD => 'F' );


create materialized view mv
  REFRESH FAST ON COMMIT
  as select * from t;