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: 166
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.

Report message to a moderator

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: 68686
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

Report message to a moderator

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: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi Michel,

Thanks a lot for the information.

Report message to a moderator

Previous Topic: How to enquire Oracle Inventory
Next Topic: ORACLE Documents.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:29:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.