Using Oracle 8i, I am trying to create a function based index, as such:<br><br>create index ulname on member(upper(last_name));<br><br>I get the following response:<br><br>ORA-00439: feature not enabled: Function-based indexes<br><br>Does anybody know what I need to do to enable function-based indexes? I have scoured the docs w/o success. I did do this:<br><br>alter session set query_rewrite_enabled=true<br>alter session set query_rewrite_integrity=trusted<br><br>But it didn't help...<br><br>Any help would be greatly appreaciated,<br><br>Joe Gotthelf
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Function Based Indexes
- Thread starter jgotthelf
- Start date