Re: index problem in oracle text

Do you have a primary key on your table?

Here is a quick example that works as long as oracle text is installed correctly. Make sure that the user who does the following has this privilege:

grant connect, resource, ctxapp to the_text_user ;

• as the the_text_user do this conn the_text_user/the_password

create table quick_clob (
 quick_id number primary key,
 text clob
);

insert into quick_clob
  ( quick_id, text )
 values
  ( 1, 'The cat sat on the mat' );

insert into quick_clob
  ( quick_id, text )
 values
  ( 2, 'The quick brown fox jumped over the lazy dog' );

commit;

create index quick_clob_idx on quick_clob ( text )  indextype is ctxsys.context;

SELECT
 score(20),
 text
FROM
 quick_clob
WHERE CONTAINS
 (text, 'near((quick, dog), 6)' ,20) > 0;

drop table quick_clob ;

"rabbit" <member43199_at_dbforums.com> wrote in message news:3498281.1066560106_at_dbforums.com...
|
| 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
|
|
| --
| Posted via http://dbforums.com
Received on Sun Oct 19 2003 - 19:01:29 CDT