Do you have Enterprize edition of the database? Function based indexes can
be created only in Enterprite edition.
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 - 18:00:49 CST
