Re: function based indexes

From: cheechong <member25671_at_dbforums.com>
Date: Sat, 01 Mar 2003 15:48:51 +0000
Message-ID: <2592173.1046533731@dbforums.com>

hi Daniel,

nope. these 2 lines are not found in my .ora file. so these are the 2 lines that are causing the problem?

--
chee chong

Originally posted by Da Morgan 


> cheechong wrote:

>

> > i was using Oracle 9i version 9.2.

> > i used to be able to create such a functional index in Oracle

>     8.1.7.

> > any idea? thanks.

>

> Did you check to see if the following are set in the initSID.ora /

> spfile?

>

> query_rewrite_enabled=TRUE

> query_rewrite_integrity=TRUSTED

>

Daniel Morgan 

--
Posted via http://dbforums.com

Received on Sat Mar 01 2003 - 09:48:51 CST