Materiliaze view in oracle

How t开发者_JS百科o create/refresh materialize view in oracle 10g.

Oracle documentation here

CREATE:

CREATE MATERIALIZED VIEW example_mview 
AS
SELECT * FROM table_name

REFRESH:

REFRESH is simply used like exec dbms_mview.refresh('example_mview');

or within the structure like

REFRESH + refresh how

  CREATE MATERIALIZED VIEW example_mview     
  REFRESH COMPLETE
  AS
  SELECT * FROM table_name

ex.

REFRESH FAST
REFRESH COMPLETE
REFRESH FAST ON DEMAND

See the documentation for other options.