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.