Hi,
I'm trying to test Oracle Text on my db but got some troubles while creating index on a column:
create table test_docs
(
id number,
text varchar2(100)
);
INSERT INTO test_docs VALUES (1, 'читать');
INSERT INTO test_docs VALUES (2, 'читаю');
INSERT INTO test_docs VALUES (3, 'читал');
INSERT INTO test_docs VALUES (4, 'чтение');
INSERT INTO test_docs VALUES (5, 'sing');
INSERT INTO test_docs VALUES (6, 'sang');
INSERT INTO test_docs VALUES (7, 'singing');
INSERT INTO test_docs VALUES (8, 'sung');
COMMIT;
begin
ctx_ddl.create_preference('my_wordlist', 'BASIC_WORDLIST');
end;
begin
ctx_ddl.create_preference('my_lexer', 'AUTO_LEXER');
ctx_ddl.set_attribute('my_lexer', 'INDEX_STEMS','YES');
end;
create index idocs on test_docs (text) indextype is ctxsys.context
parameters ('LEXER my_lexer WORDLIST my_wordlist');
Error appears on the last sentence and looks like this:
ORA-29855: error occured in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index does not exist
DRG-11135: feature not generally available
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
Could you please explain what goes wrong here?
P. S. And explain what tag should I use for formatting code here