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;