Re: Error while Creating function based index in Oracle 8

Function-based indexes are a feature of the *Enterprise* edition of 8.1. I'll lay odds you have the Standard edition, which means you can't do what you're trying to do.

You'll find that you can't create a bitmapped index either (I suspect).

If this is a real environment you're working in, time for them to shell out some more cash and upgrade. If it's an evaluation environment, time to download the full Enterprise edition from technet.

Good luck
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"kush" <kdhakal_at_eline.com> wrote in message
news:Wtzx5.239$Cn1.12768_at_sjc-read...


> I am trying to create function based index in a table but the system gives

> me error messege of:

>    ORA-00439: feature not enabled: Function-based indexes

> Now, where can I see if the feature is enabled or not and If it is

 disabled


> can I enable it now.

> Oracle version is 8.1.5

> Your help is appreciated

>

>