| function based indexes error in oracle 8.1.7 [message #90514] |
Mon, 05 January 2004 21:23  |
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  |
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'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
