rabbit
10-22-2003, 09:05 AM
hi,
Do you know, how can i correctly creat the index in oracle text? I
have created a text table:
CREATE TABLE texttable(text_id int PRIMARY KEY not null, titel
varchar2(500), author varchar2(20), datum date, text_size int,
text_typ varchar2(10), content CLOB)
I have inserted the documents in content column. text_typ column is
the format column (text or binary)help for the filtering. I want to
create an index for the column content.
CREATE INDEX oracle_index ON texttable(content) INDEXTYPE IS
CTXSYS.CONTEXT PARAMETERS('
DATASTORE CTXSYS.DEFAULT_DATASTORE
FILTER CTXSYS.INSO_FILTER format column text_typ
LEXER oracle_lexer_intern
WORDLIST oracle_wordlist_intern
')
I get always the erro message:
java.sql.SQLException: ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11000: invalid keyword CTXSYS.INSO_FILTER
ORA-06512: in "CTXSYS.DRUE", line 157
ORA-06512: in "CTXSYS.TEXTINDEXMETHODS", line 186
I don't understand why inso_filter is an invalid keyword. I have seen
the same example for INSO_FILTER in the documentation Oracle Text
Reference Release 9.2.
How can I solve the problem? Can you give me any suggestions?
(I think, perhaps this is the problem for the setting classpath. I
don't know which package shall i use for oracle text and his classpath
set. I can not find anything about the oracle text classpath
information. If you know, can you give me the information? )
Thank you very much. Greetings from Germany.
rabbit
Do you know, how can i correctly creat the index in oracle text? I
have created a text table:
CREATE TABLE texttable(text_id int PRIMARY KEY not null, titel
varchar2(500), author varchar2(20), datum date, text_size int,
text_typ varchar2(10), content CLOB)
I have inserted the documents in content column. text_typ column is
the format column (text or binary)help for the filtering. I want to
create an index for the column content.
CREATE INDEX oracle_index ON texttable(content) INDEXTYPE IS
CTXSYS.CONTEXT PARAMETERS('
DATASTORE CTXSYS.DEFAULT_DATASTORE
FILTER CTXSYS.INSO_FILTER format column text_typ
LEXER oracle_lexer_intern
WORDLIST oracle_wordlist_intern
')
I get always the erro message:
java.sql.SQLException: ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11000: invalid keyword CTXSYS.INSO_FILTER
ORA-06512: in "CTXSYS.DRUE", line 157
ORA-06512: in "CTXSYS.TEXTINDEXMETHODS", line 186
I don't understand why inso_filter is an invalid keyword. I have seen
the same example for INSO_FILTER in the documentation Oracle Text
Reference Release 9.2.
How can I solve the problem? Can you give me any suggestions?
(I think, perhaps this is the problem for the setting classpath. I
don't know which package shall i use for oracle text and his classpath
set. I can not find anything about the oracle text classpath
information. If you know, can you give me the information? )
Thank you very much. Greetings from Germany.
rabbit