When I try to create function-based index it says that the option is not supported. I have Oracle 8.1.5 Standard Edition. Is this edition provides function-based indexes or I need the Enterprise edition?
Do you have the COMPATIBLE initialisation parameter set?
If not this should be defaulting to Version 8.0.0.
To use new features of 8i this parameter must be set to the
version of oracle that contains the features you wish to use
ie. If you have no applcation conflicts with any feature in 8.1.5
i suggest you set the parameter to 8.1.5....
In the init file for the database insert the line (If not already there)
This will require the database to the shutdown and restarted.
Hope this helps....
Let me know if it solves the problem
Click Here to Expand Forum to Full Width