SQL2K MSDAORA Link to Oracle 8i

  • I use links to Oracle 8i from SQL2000 quite often. Recently the Oracle DBA added a "Function Index" on a column on a table I link to. I began to receive an "invalid schema definition" error message. The Oracle client I am using on the server is Any suggestions?

  • Not sure what a "Function Index" is.

    No real idea. Don't find anything on MSDN or Technet. Perhaps Oracle has some ideas?

    Steve Jones


  • A function index is used to prevent a table scan on an indexed field. Let's say there is a field NAMES that is indexed. Using a RTRIM on that field in a query would force a table scan. You can set up a function index with the syntax RTRIM that would create a index based on that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply