| 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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
