Re: function based indexes

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Fri, 15 Nov 2002 05:28:05 -0600
Message-ID: <ut9mi6adhaem04@corp.supernews.com>

Check to ensure COMPATIBLE is set to the correct version.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Kumar" <kumar_kmk_at_hotmail.com> wrote in message news:bce41b15.0211141802.7872a762_at_posting.google.com...
> Hi
> I am trying to create a function based index and getting
> ORA-00439 : feature not enabled function based indexes.
>
> I looked in v$option table and i find the parameter "function based
> indexes" with value false.
>
> Question: how do i make it true (to enable fn based index)
>
> I tried like this:
> " update v$option set value ='true' where parameter like
> 'Function-based indexes'
> I got an error saying can only select from fixed tables/views
>
> Thanks for any responses
>
> kumar
Received on Fri Nov 15 2002 - 05:28:05 CST