OraFAQ Forum: Text & interMedia » ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

Home » Server Options » Text & interMedia » ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine [message #314042]

Tue, 15 April 2008 11:55

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

When i try to create context index on a table using below command

CREATE INDEX tx_id_temp ON search_attributes_temp
(bus_name)
INDEXTYPE IS ctxsys.CONTEXT

i am getting error

CREATE INDEX tx_id_temp ON search_attributes_temp
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: TX_ID_TEMP
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 219

But when I search for this index using sql

select * 
  from all_objects 
 where object_name = 'TX_ID_TEMP'

I can see it created....

confused..

even i tried with dropping the index..same error

[Updated on: Tue, 15 April 2008 11:56]

Report message to a moderator

Re: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine [message #314085 is a reply to message #314042]

Tue, 15 April 2008 15:17

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

First make sure that tx_id_temp is not an index on another table. Then you can try:

DROP INDEX tx_id_temp FORCE;

If you suspect that the index was created using double quotes that might have made the name case-sensitive, then try things like:

DROP INDEX "tx_id_temp";

or

DROP INDEX "Tx_ID_Temp";

If you do not yet have data in your table, you may be able to solve the problem by dropping the table, which should drop the index with it.

Sometimes, when things go wrong there are pieces of objects associated with an index left and it can be difficult to thoroughly clean up all of the pieces. You may end up being better off with a new table name and new index name to avoid future problems.

Report message to a moderator

Re: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine [message #314087 is a reply to message #314042]

Tue, 15 April 2008 15:19

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

One more thing. Make sure that you have not just done:

CREATE INDEX ... ;
/

If so, the semi-colon (;) would execute the create statement once and the slash (/) would execute the same statement a second time, which would produce the error, since the index was already created the first time.

Report message to a moderator

Previous Topic:	Trying to create Index with Multi column Datastore parameter gives error
Next Topic:	Source of the hit on a concatenated datastore?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 07:42:31 CST 2024