Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> interMedia and Function-Based-Indexes
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:
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