Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Use materialized view's query rewrite

Use materialized view's query rewrite

From: <okman_at_my-deja.com>
Date: Thu, 09 Nov 2000 06:35:12 GMT
Message-ID: <8udgj0$4q9$1@nnrp1.deja.com> 






Dear all,



I am trying to create a materialized view with
the "ENABLE QUERY REWRITE" option. I have set
the "QUERY_REWRITE_ENABLED = TRUE" for the
database. However, I encounter the Oracle
error "ORA-00439: feature not enabled:


Materialized view rewrite".


I wonder if query rewrite is a feature only
available for Enterprise version of Oracle
Database (like bitmap index). Any idea ?



Thanks in advance.



O.K.Man




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Thu Nov 09 2000 - 00:35:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US