Re: Use materialized view's query rewrite

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 9 Nov 2000 21:49:24 +1100
Message-ID: <3a0a8171@news.iprimus.com.au>

I would say 'got it in one'.

I bet you can't used function-based indexes either, huh?

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


<okman_at_my-deja.com> wrote in message news:8udgj0$4q9$1_at_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 - 04:49:24 CST