OraFAQ Forum: Test » getting error ora-29855

Home » Other » Test » getting error ora-29855 (oracle 10g)

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

getting error ora-29855 [message #376573]

Wed, 17 December 2008 22:39

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

Error starting at line 7,238 in command:
CREATE INDEX ICD9_DATA_INDEX ON EMRENCOUNTERDATA
(ICD9_DATA)
INDEXTYPE IS CTXSYS.CONTEXT
Error report:
SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-00955: name is already used by an existing object
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

Report message to a moderator

Re: getting error ora-29855 [message #376759 is a reply to message #376573]

Thu, 18 December 2008 08:41

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

ORA-00955: name is already used by an existing object

Isn't the error message clear enough ?

Report message to a moderator

Re: getting error ora-29855 [message #376763 is a reply to message #376759]

Thu, 18 December 2008 08:51

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is NOT a message to be answered, this is just a posting test, the actual one is posted in the appropriate forum.

But maybe you just wanted to test how to answer. Smile

Regards
Michel

Report message to a moderator

Re: getting error ora-29855 [message #376915 is a reply to message #376763]

Fri, 19 December 2008 02:48

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Oops Blinded by the light

Report message to a moderator

Previous Topic:	testing
Next Topic:	Test long lines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 10:28:10 CST 2024