Home » RDBMS Server » Server Administration » Enabling Materialized view rewrite
Enabling Materialized view rewrite [message #234077] Sun, 29 April 2007 10:27 Go to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Hi,

I am trying to run a qury for the Snapshot Creation. While running the query I get the below mentioned error message.
ORA-00439: feature not enabled: Materialized view rewrite

I am running this quer as SYS. Also the value of Materialized view rewrite is FALSE. Please guide me to change this value to TRUE and to run the query successfully.
Re: Enabling Materialized view rewrite [message #234080 is a reply to message #234077] Sun, 29 April 2007 11:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Never ever use SYS but for maintenance purpose
2/ Materialized view rewrite is only available with Entreprise Edition.

Regards
Michel
Re: Enabling Materialized view rewrite [message #234189 is a reply to message #234077] Mon, 30 April 2007 05:57 Go to previous message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Hi Michel,

Thanks a lot for the information.
Previous Topic: How to enquire Oracle Inventory
Next Topic: ORACLE Documents.
Goto Forum:
  


Current Time: Thu Dec 08 12:19:00 CST 2016

Total time taken to generate the page: 0.21223 seconds