Hi!
I want to use Intermedia text to index a column in a table.
I'm trying to set it up but I'm having a few problems:
- First I can't create the index because my Language is not recognised by
oracle when building the index.
I get:
DRG-11440: operação não suportada para a língua PORTUGUESE
(it reads as: operation not supported for language PORTUGUESE)
but the intermedia text has the stop words for Portuguese language so I
don't know why this is not accepted.
Shall I set my database to english?
- To override this, I was trying to set up some preferences running this:
SQL> begin
2 ctx_dll.create_preference('piaf_lexer','BASIC_LEXER');
3 ctx_dll.set_attribute('piaf_lexer','INDEX_TEXT','YES');
4 ctx_dll.set_attribute('piaf_lexer','INDEX_THEMS','NO');
5 end;
6 /
But I've got an error saying that the 'CTX_DLL.CREATE_PREFERENCE' should
have been declared.
What else do I need to do to build up the preferences? I'm using the user
CTXSYS for this.
- For last is my major problem: I need to do something like the alternate
spelling for Germany.
I need to convert a char to one other before indexing. I need to convert the
letters like "á" to the letter
without the accent "a". I can do this with a USER_FILTER but... isn't there
any other way?
What I want to do is something like this:
create index MY_INDEX on MY_TABLE(translate(MY_COL, 'áàâãä','aaaaa')
indextype is ctxsys.context;
Any help with this will be apreciated.
Tnx in advance,
Paulo Santos
Received on Sat Jul 21 2001 - 16:35:05 CDT