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