ALTER MATERIALIZED VIEW [schema .] (materialized_view) [ physical_attributes_clause | data_segment_compression | LOB_storage_clause [, LOB_storage_clause]... | modify_LOB_storage_clause [, modify_LOB_storage_clause]... | alter_table_partitioning | parallel_clause | logging_clause | allocate_extent_clause | { CACHE | NOCACHE } ] [alter_iot_clauses] [USING INDEX physical_attributes_clause] [ MODIFY scoped_table_ref_constraint | REBUILD | alter_mv_refresh ] [ { ENABLE | DISABLE } QUERY REWRITE | COMPILE | CONSIDER FRESH ] ;