While trying to repository instance installation following error comes up
"ORA 00439: feature not enabled materialized view rewrite"
Long term repository installed on Oracle Standard edition
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
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
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy