ORA-00439: feature not enabled: Materialized view rewrite

Check the Materialized view rewrite option is enable or disable

Select * from v$option where lower(parameter) like 'materialized%'

PARAMETER                    VALUE
---------------------             --------------
Materialized view rewrite      FALSE

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


if you check on EE then you will got the output

SQL> SELECT * FROM v$option WHERE LOWER(parameter) LIKE '%aterialized%';

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