| Ghost index [message #76062] |
Tue, 22 July 2003 06:37 |
Juan Salvador
Messages: 4
Registered: July 2003
|
Junior Member |
|
|
Hello,
I created and Intermedia index but it did not finish succesfully (the oracle session which issued the create command was killed abruptly). If I query the CTX_INDEX table, I can see the index there, it even has an INDEXED status, but when I try to drop it I get an "ORA-01418: specified index does not exist" message. However, a CREATE INDEX sentence with that index name has as result an "ORA-29855: error occurred in the execution of ODCIINDEXCREATE routin
ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: INDICE_URL
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186" message.
The index exists and doesn't exist at the same time. Uff, too much for an index, isn`t it? The question is, how can I drop it for good? Does anybody know the reason of this?
Thank you in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
