A materialized view is a stored view query result.
The data on which the view is defined is referred to as the master table (or tables). The materialized view is stored in its own table, which is refreshed based on changes to the master table. A materialized view may be local, in which it is defined on the same database as the master table, or remote, in which the materialized view is defined on a different database than the master table.
A materialized view is a stored view query result. The data on which the view is defined is referred to as the master table (or tables). The materialized view is stored in its own table, which is refreshed based on changes to the master table. A materialized view may be local, in which it is defined on the same database as the master table, or remote, in which the materialized view is defined on a different database than the master table.
Oracle supports these types of materialized views:
Read-only – materialized view content is derived from the corresponding master table or tables, and the view content cannot be changed.
Writeable – materialized view content can be changed temporarily, but any changes are overwritten when the table containing the materialized view is refreshed based on changes to the corresponding master table or tables.
Updatable – updates made to a materialized view are written back to the corresponding master table or tables when the materialized view is refreshed.
For a complete description of materialized views, see the Oracle documentation.