Re: Function Based Index Problem

"Sean Dolan" <nospam_at_nowhere.com> wrote in message news:9go84u01b41_at_enews1.newsguy.com...
> I have freshly installed Oracle 8.1.7.0 for Win 2000 and am having a
 problem
> creating a function based index.
>
> The command I have is :
> create index i$category$hint on CATEGORY
> (upper(display), cat_id, parent_cat_id);
>
> When I try it, I get :
> ERROR at line 2:
> ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
>
> So you'd think it was not Enterprise Edition, but a query on v$version
 gives
> me:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> PL/SQL Release 8.1.7.0.0 - Production
> CORE 8.1.7.0.0 Production
> TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> And if you look at v$option, you will see that Function Based Index is set
> to TRUE.
>
> Any ideas what could be going wrong here?
> Thanks,
> Sean
>
>

Did you *read* the error message and verify it in the server messages manual?

> ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or

Now please verify the your compatible parameter using show parameter compatible.
You will notice the error message is probably right. Edit init.ora, set the compatible parameter to at least 8.1.0.0.0 and bounce the instance.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jun 19 2001 - 16:53:54 CDT