MATERIALIZED VIEW

·         It is a static view

·         It holds data in it

·         Materialized view takes the snapshot of the data whenever it is created or refreshed.

·         It will not support DML on it

·         DML on table will not be reflected in view

·         To create it “create materialized view “permission is required to the user who is creating it.

·         It is used to maintain historic data.

·         It is used for data analysis and reporting purpose.

·         Materialized are mainly created to over come the performance issues and to maintain historic data.

Syntax:-

Create or replace materialized view <view name>

Refresh complete

With rowid

Start with sysdate

Next sysdate