Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> interMedia and Function-Based-Indexes

interMedia and Function-Based-Indexes

From: Markus Schwabe <mschwabe_at_gscout.de>
Date: 2000/08/08
Message-ID: <8mp9vo$8io$1@koroth.muc.eurocyber.net>#1/1

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 Received on Tue Aug 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US