how to enable feature for function-based indexes [message #51042] |
Mon, 22 April 2002 21:53 |
PRAKASH PRATAPE
Messages: 5 Registered: April 2002
|
Junior Member |
|
|
Dear Friends,
I am giving following command
create index idx_x on x(sal+1);
which gives error
ora-00439:feature not enabled:function-based indexes.
How will I be able to enable feature of function index
in my server of oracle 8i.
Prakash Pratape.
|
|
|
Re: how to enable feature for function-based indexes [message #51043 is a reply to message #51042] |
Mon, 22 April 2002 22:03 |
saleem
Messages: 65 Registered: January 2002
|
Member |
|
|
You have most likely not purchased the version of oracle that allows this to be created. even though function based indexes are a 8i feature, if you are running on the standard version of 8i then you will not have the ability. i think you need to be running the enterprise edition to be able to create them.
do this :
select * from v$option; -- to see what your version is capable of.
|
|
|