Home » Server Options » Text & interMedia » index problem in oracle text
index problem in oracle text [message #76071] Sun, 19 October 2003 05:16
Messages: 6
Registered: October 2003
Junior Member
Do you know, how can i correctly creat the index in orcale text? I have created a text table:
CREATE TABLE texttable_intern(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). I want to create an index for the column content.
CREATE INDEX oracle_index_intern ON texttable_intern(content) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('
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

I don't understand why inso_filter is an invalid keyword. I have seen the same example for INSO_FILTER in Oracle Text Reference Release 9.2.

How can I solve the problem? Can you give me any suggestions?

Thank you very much. Greetings from Germany.

Previous Topic: ORA-03113 error while creating text index
Next Topic: logon problem
Goto Forum:

Current Time: Wed Feb 22 09:47:55 CST 2017

Total time taken to generate the page: 0.18989 seconds