Home » Other » General » Re: error message
Re: error message [message #101965] Thu, 13 December 2001 02:16
RIN
Messages: 1
Registered: December 2001
Junior Member
Hi Andrew

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

You must drop the index first. Occasionally, it may be necessary to do the following:

DROP INDEX indexname FORCE;

The reason behind this is that unlike standard B-tree indexes, it is possible for an Oracle Text (interMedia Text) index to be partially complete. Maybe some rows were not indexed properly, or maybe the index creation failed at the last moment and we can continue where we left off. Hence, once you have started an index creation, the kernel will assume that index exists until told otherwise.

Rgds,
Rin

----------------------------------------------------------------------
Previous Topic: Re: OCP questions/ sql/plsql
Next Topic: sqlplus - default open directory
Goto Forum:
  


Current Time: Thu Mar 28 11:44:29 CDT 2024