Re: Function-Based Index

From: Klaus Zeuch <KZeuch_at_nospamhotmail.com>
Date: 2000/07/22
Message-ID: <8lc4u5$3qv$15$1@news.t-online.com>#1/1

Check your init.ora for parameter-setting COMPATIBLE=8.1.0
Function-based indexes are one of these "Features Requiring 8.1.0 or Higher Compatibility Level"

Klaus

"Natalia" <nat_at_fcc.net> schrieb im Newsbeitrag 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 Sat Jul 22 2000 - 00:00:00 CDT