Home » Server Options » Text & interMedia » Why I can't create context index on ORACLE8i
Why I can't create context index on ORACLE8i [message #366428] Fri, 31 March 2000 00:30 Go to next message
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
Re: Why I can't create context index on ORACLE8i [message #366438 is a reply to message #366428] Mon, 07 August 2000 07:19 Go to previous message
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
Previous Topic: BASE LETTER SUPPORT
Next Topic: Help requested - context cartridge
Goto Forum:
  


Current Time: Mon Oct 20 14:13:45 CDT 2014

Total time taken to generate the page: 0.14152 seconds