Home » Developer & Programmer » Designer » function based indexes error in oracle 8.1.7
function based indexes error in oracle 8.1.7 [message #90514] Mon, 05 January 2004 21:23 Go to next message
jom
Messages: 3
Registered: January 2004
Junior Member
I have an Oracle related issue.The problem was identified past weekend when importing data to SQC DB server.Errors occurred during the data loading, actually same error on different "create index" statements.
Error >>
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Function-based indexes

Sir i am using Oracle 8.1.7

Sir please have a solution to this.

jom
Re: function based indexes error in oracle 8.1.7 [message #90528 is a reply to message #90514] Fri, 23 January 2004 02:45 Go to previous message
Shesh
Messages: 16
Registered: July 2003
Junior Member
Query V$option table and see whether the 'Function-Based Indexes' is installed or not.

Try this

Grant QUERY REWRITE privilege to the user.
Make sure that parameter
query_rewrite_enabled is TRUE and
query_rewrite_integrity is 'TRUSTED'
Previous Topic: Actual Space taken by Varchar2
Next Topic: form module creation
Goto Forum:
  


Current Time: Tue Mar 19 03:41:35 CDT 2024