Materialized view log

Before creating materialized view in fast refresh mode ,it is necessary to create materialized view log for the table which the view needs to be created.

The syntax for creating materialized view log is

CREATE MATERIALIZED VIEW LOG on TABLE_NAME

Once the log is created then we can create materialized view with fast refresh option.

For more idea about it ,please cisit the following site:

http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_6003.htm