ORA-00439: feature not enabled: Materialized view rewrite

   When trying to create a materialized view in SQL*Plus an error is returned:



 create materialized view mvprab
  refresh fast on commit
  enable query rewrite
  as
    select
     a    ,
   b  ,
     c ,
     ,
 
    from
      p, p1
    where
      p.a= p1.a
;

  Check the Materialized view rewrite option is enable or disable


PARAMETER                                              VALUE
------------------                                             -------------------
Materialized view rewrite                                FALSE
Materialized view warehouse refresh              FALSE


standard  edition not allow to use the Materialized view Query rewrite option