CREATE MATERIALIZED VIEW [schema.]materialized_view
  [OF [schema.]object_type] 
  [(scoped_table_ref_constraint)]
  ON PREBUILT TABLE [{WITH | WITHOUT} REDUCED PRECISION]
  | physical_properties materialized_view_props
  [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;