ALTER MATERIALIZED VIEW [schema .] (materialized_view) [ physical_attributes_clause | LOB_storage_clause [, LOB_storage_clause]... | modify_LOB_storage_clause [, modify_LOB_storage_clause]... | partitioning_clauses | parallel_clause | { LOGGING | NOLOGGING } | allocate_extent_clause | { CACHE | NOCACHE } ] [alter_iot_clauses] [USING INDEX physical_attributes_clause] [ MODIFY scoped_table_ref_constraint | REBUILD | refresh_clause ] [ { ENABLE | DISABLE } QUERY REWRITE | COMPILE | CONSIDER FRESH ] ;
For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.