Refreshes the data in a materialized view.

Syntax


REFRESH MATERIALIZED VIEW viewName;

Arguments

  • viewName: The name of an existing materialized view.

Additional Information

  • The user must have the UPDATE privilege to refresh a materialized view.

  • CREATE VIEW - to create Materialized Views.

Examples


REFRESH MATERIALIZED VIEW ORACLE1.oracle.INVENTORY.custview22;