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
]
;