.alter materialized-view autoUpdateSchema

Sets the autoUpdateSchema value of an existing materialized view to true or false. For information on the the autoUpdateSchema property, see materialized view create command properties.

.alter materialized-view MaterializedViewName autoUpdateSchema [true|false]

Note

You must either be the database user who created the materialized view or have database admin permission to run this command.

Examples

.alter materialized-view MyView autoUpdateSchema true

.alter materialized-view MyView autoUpdateSchema false