ALTER MATERIALIZED VIEW

This command alters the specified materialized view.

Syntax

ALTER MATERIALIZED VIEW <mv_identifier> 
    SET <mv_option> = <value>; 

Note that not all materialized view options are mutable.

To check if a table option is mutable, see CREATE MATERIALIZED VIEW.