Oracle Materialized Views

 

Create MV:

----------------

CREATE MATERIALIZED VIEW <MV_NAME> REFRESH WITH ROWID AS SELECT * FROM <MV_NAME> where <CONDITION>;

CREATE MATERIALIZED VIEW <MV_NAME> REFRESH WITH ROWID AS SELECT * FROM <MV_NAME>;

TO SCHEDULE AND REFRESH mv DAILY:

------------------------------------------------

EXEC DBMS_MVIEW.REFRESH('<MV_NAME>');

to Drop MV: 

------------------------

DROP MATERIALIZED VIEW <MV_NAME>;

GRANT access to any user:

------------------------------

GRANT SELECT ON <MV_NAME> TO <USERNAME>;