Home » Server Options » Text & interMedia » index error (10g)
index error [message #348268] Tue, 16 September 2008 04:38 Go to next message
jimsang
Messages: 13
Registered: May 2008
Junior Member
my code:

CREATE INDEX T_SHOP_INDEX ON T_SHOP (S_NAME) INDEXTYPE IS ctxsys.CONTEXT
PARAMETERS('datastore shop_column LEXER shop_lexer');


but alert error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drsinbind
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\GIGI\TEMP01.DBF'
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

why ? thanks a lot
Re: index error [message #348376 is a reply to message #348268] Tue, 16 September 2008 10:01 Go to previous message
Barbara Boehmer
Messages: 7932
Registered: November 2002
Location: California, USA
Senior Member
It looks like your error message is saying that this file is corrupted:

D:\ORACLE\PRODUCT\10.1.0\ORADATA\GIGI\TEMP01.DBF
Previous Topic: Oracle Text added column name to tokens
Next Topic: package and oracle text search AND SOS,SOS,Search,Search,SOS (merged by bb)
Goto Forum:
  


Current Time: Wed Jul 23 05:11:40 CDT 2014

Total time taken to generate the page: 0.06827 seconds