Function Based Index Problem

From: Sean Dolan <nospam_at_nowhere.com>
Date: Tue, 19 Jun 2001 13:11:46 -0600
Message-ID: <9go84u01b41@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 Received on Tue Jun 19 2001 - 14:11:46 CDT