CREATE MATERIALIZED VIEW [schema .] materialized_view 
[OF [schema .] object_type] [( scoped_table_ref_constraint )]
[ORGANIZATION INDEX index_org_table_clause]
[ materialized_view_props | prebuilt_table_clause ]
[ USING INDEX 
  [{ physical_attributes_clause | TABLESPACE tablespace }
   [ physical_attributes_clause | TABLESPACE tablespace ]...
  ] 
| USING NO INDEX
]
[create_mv_refresh]
[FOR UPDATE] [{ DISABLE | ENABLE } QUERY REWRITE] AS subquery;