Home » Other » Test » getting error ora-29855 (oracle 10g)
getting error ora-29855 [message #376573] Wed, 17 December 2008 22:39 Go to next message
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
Re: getting error ora-29855 [message #376759 is a reply to message #376573] Thu, 18 December 2008 08:41 Go to previous messageGo to next message
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 ?
Re: getting error ora-29855 [message #376763 is a reply to message #376759] Thu, 18 December 2008 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: getting error ora-29855 [message #376915 is a reply to message #376763] Fri, 19 December 2008 02:48 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Laughing

Oops Blinded by the light
Previous Topic: testing
Next Topic: Test long lines
Goto Forum:
  


Current Time: Thu Mar 28 06:05:03 CDT 2024