materialized View

hi,

A Materialized View is effectively a database table that contains the results of a query. The power of materialized views comes from the fact that, once created, databse server can automatically synchronize a materialized view's data with its source information as required with little or no programming effort.

Materialized views can be used for many purposes, including:

    * Denormalization
    * Validation
    * Data Warehousing
    * Replication.

hope this help.

http://www.databasejournal.com/features/oracle/article.php/2192071/Materialized-Views-in-Oracle.htm

Hi Arjun,

A materialized view is a replica of a target master from a single point in time. The master can be either a master table at a master site or a master materialized view at a materialized view site. Whereas in multimaster replication tables are continuously updated by other master sites, materialized views are updated from one or more masters through individual batch updates, known as a refreshes, from a single master site or master materialized view site

Please refer the below link

http://docs.oracle.com/cd/B10501_01/server.920/a96567/repmview.htm

Thanks