CREATE MATERIALIZED VIEW [schema .] materialized_view [OF [schema .] object_type] [( scoped_table_ref_constraint )] [ORGANIZATION INDEX index_org_table_clause] [ { { segment_attributes_clause | column_properties | { CACHE | NOCACHE } } [ segment_attributes_clause | column_properties | { CACHE | NOCACHE } ]... | CLUSTER cluster ( column [, column]... ) } [{ partitioning_clauses | parallel_clause | build_clause } [ partitioning_clauses | parallel_clause | build_clause ]... ] | ON PREBUILT TABLE [{ WITH | WITHOUT } REDUCED PRECISION] ] [ USING INDEX [{ physical_attributes_clause | TABLESPACE tablespace } [ physical_attributes_clause | TABLESPACE tablespace ]... ] | USING NO INDEX ] [refresh_clause] [FOR UPDATE] [{ DISABLE | ENABLE } QUERY REWRITE] AS subquery;
For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.