Home » Server Options » Text & interMedia » Ghost index
Ghost index [message #76062] Tue, 22 July 2003 06:37
Juan Salvador
Messages: 4
Registered: July 2003
Junior Member
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.
Previous Topic: INSO filter problems
Next Topic: how to use user lexer in stored procedure
Goto Forum:

Current Time: Mon Aug 08 05:06:43 CDT 2022