Error while Creating function based index in Oracle 8 
Author Message
 Error while Creating function based index in Oracle 8
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


Sat, 08 Mar 2003 09:40:06 GMT
 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
--------------------------------------------------------------------------


Quote:
> 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



Sat, 08 Mar 2003 11:12:13 GMT
 Error while Creating function based index in Oracle 8
Find them from select * from v$option;

Yong Huang


Quote:
> 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



Wed, 18 Jun 1902 08:00:00 GMT
 Error while Creating function based index in Oracle 8
This is an option available with Enterprise Edition not the Standard
Edition.
Quote:
-----Original Message-----

Posted At: Monday, September 18, 2000 9:40 PM
Posted To: server
Conversation: Error while Creating function based index in Oracle 8
Subject: Error while Creating function based index in Oracle 8

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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ORA-01031 with Create Index for a Function Based Index

2. How I can create a function-based index ?

3. can't create function-based index

4. Creating Function-Based Indexes

5. Function Based Index in Oracle 8

6. Oracle 8i and function-based indexes

7. Function-based indexes in Oracle 8i

8. Oracle user defined Function based index and Ora-4020

9. oracle function based index not being utilized

10. Function based indexes and index fast full scan

11. Create view based on Oracle tables error

12. Function Based indexes in SQL Server


 
Powered by phpBB® Forum Software