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

[Message index]

		ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine By: navkrish on Tue, 15 April 2008 11:55
		Re: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine By: Barbara Boehmer on Tue, 15 April 2008 15:17
		Re: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine By: Barbara Boehmer on Tue, 15 April 2008 15:19

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: Thu Apr 25 01:00:51 CDT 2024