Re: Function Based Index Problem

Sean Dolan wrote:

> 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

Look in the initSID.ora for the compatible parameter. It appears to be set for an older version.

Daniel A. Morgan Received on Tue Jun 19 2001 - 17:24:01 CDT