OraFAQ Forum: Text & interMedia » Why I can't create context index on ORACLE8i

Home » Server Options » Text & interMedia » Why I can't create context index on ORACLE8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why I can't create context index on ORACLE8i [message #366428]

Fri, 31 March 2000 00:30

sheldon
Messages: 3
Registered: March 2000

Junior Member

I am using oracle8.1.5 on windows NT 4.0, after I installed a new database ,I executed following statements to create a context index , it failed, can anyone tell me how to do? thx

create table test (
a integer primary key,
b clob );
insert into test values (1,'testtest');
commit;
create index test_b on test(b) indextype is ctxsys.context;

the last statement fails:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
DRG-11422: linguistic initialization failed
DRG-00100: internal error, arguments : 52100,[[drxf.c]],707,gxtopen,0
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

Report message to a moderator

Re: Why I can't create context index on ORACLE8i [message #366438 is a reply to message #366428]

Mon, 07 August 2000 07:19

sharan alva
Messages: 57
Registered: November 1999

Member

You have run into a bug which states that NLS_LANG variable may not be set correctly. The NLS_LANG variable must be set to American_America when trying to create an index

Report message to a moderator

Previous Topic:	BASE LETTER SUPPORT
Next Topic:	Help requested - context cartridge

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:23:26 CST 2024