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.