-
Title
Error: "ORA 00439: feature not enabled materialized view rewrite" -
Description
While trying to repository instance installation following error comes up
"ORA 00439: feature not enabled materialized view rewrite" -
Cause
Long term repository installed on Oracle Standard edition
-
Resolution
To resolve this issue make sure that the Performance Analysis Repository instance is on Oracle 8.1.7 or later and the following parameters must be set:
query_rewrite_enabled=true
star_trasformation_enabled = true
sort_area_size = 3145728
-
Attachments
-
Additional Information
Note: another common reason for this error is the long term repository is being installed on Oracle Standard edition.
If the Performance Analysis long term repository is being installed on Oracle Standard edition, please see the zip file attached containing the required scripts and readme file.
Also, please be advised the total number of instances supported by PA repository running on Oracle Standard Edition is 5