Re: Function-Based Index

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/25
Message-ID: <397cfc78$1@news.iprimus.com.au>#1/1

Wild stab in the dark here, but have you got the Enterprise Edition? I suspect that function-based indexes may only available in the Enterprise Edition. But I may be totally wrong.

Regards
HJR "Natalia" <nat_at_fcc.net> wrote in message news:3978FF38.597690A9_at_fcc.net...
> I am trying to create a function-based index in Oracle 8.1.5 with this
> syntax
>
> CREATE INDEX fun_ind_pop_01 ON
> census(10*population-population*population)
>
> and get this message:
>
> ORA-00439: feature not enabled: Function-based indexes.
>
> I did the
> alter session set query_rewrite_enabled=true
> and
> alter session set query_rewrite_integrity=trusted
>
> What else can I try?
>
>
>
Received on Tue Jul 25 2000 - 00:00:00 CDT