MWM v2 Standard Edition Database Support And Error 'ORA-00439: feature not enabled: Materialized view rewrite' (Doc ID 1576109.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Oracle Real-Time Scheduler - Version 2.1.0 and later
Information in this document applies to any platform.

Goal

A test system was installed with MWM Demo Data on Oracle Database Enterprise Edition (EE).  We have taken an export to load in a new production system on Oracle Database Standard Edition (SE).  The ORA error message below was displayed when creating a new MWM database on the import utility to SE:


The MWM DBA guide support section describes that MWM was tested, and is supported, on enterprise and standard edition. However, materialized view rewrite is not supported in Oracle standard edition. Are materialized views required with the rewrite query option? How should this error be addressed in Standard Edition?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms