From: "Markus Schwabe" <mschwabe@gscout.de>
Subject: interMedia and Function-Based-Indexes
Date: 2000/08/08
Message-ID: <8mp9vo$8io$1@koroth.muc.eurocyber.net>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Complaints-To: abuse@cybernet-ag.net
X-Trace: koroth.muc.eurocyber.net 965749560 8792 195.143.12.114 (8 Aug 2000 15:46:00 GMT)
Organization: Cybernet AG
X-MSMail-Priority: Normal
NNTP-Posting-Date: 8 Aug 2000 15:46:00 GMT
Newsgroups: comp.databases.oracle.misc


Hi *,

is it right that interMedia does not support Function-Based-Indexes?

A call of

CREATE INDEX Test ON Partner (substr(dc(Name), 1, 120));

works fine, but a call of

CREATE INDEX Test ON Partner (substr(dc(Name), 1, 120))
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('LEXER CTXSYS.DEFAULT_LEXER WORDLIST CTXSYS.DEFAULT_WORDLIST');

gives me an error:

CREATE INDEX Ctx_MV_Partner_Idx_Name ON MV_Partner (substr(dc(Name), 1, 120))
                                                    *
ERROR in Zeile 1:
ORA-29883: cannot create a domain index on column expressions

Server is Oracle 8.1.6 EE on Solaris 2.6, Client is WinNT SP5.

TIA
Markus