| index error [message #348268] |
Tue, 16 September 2008 04:38  |
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  |
 |
Barbara Boehmer
Messages: 9104
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
