| index problem in oracle text [message #76071] |
Sun, 19 October 2003 05:16 |
rabbit
Messages: 6
Registered: October 2003
|
Junior Member |
|
|
hi,
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('
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 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.
rabbit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
