Home » RDBMS Server » Networking and Gateways » specified index does not exist while rebuilding the index
specified index does not exist while rebuilding the index [message #201733] Mon, 06 November 2006 09:29 Go to next message
litalh
Messages: 4
Registered: November 2006
Junior Member
Hi all,

This problem occures only sometimes. I'm getting the list of indexes from the user_indexes table and later perform on them a rebuild operation by using the command :
Alter index index_name coalesce

This might cause on some indexes to the following error:
ORA-01418: specified index does not exist

I know these indexes exist and I didn't find any reson for this situation.

Does anyone have any idea about it ?

Thanks,
Lital
Re: specified index does not exist while rebuilding the index [message #201777 is a reply to message #201733] Mon, 06 November 2006 12:32 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does your problem have to do with Networking Services? Also, you've already started the same topic in the General Forum; I'll lock this one. Please, don't cross-post and continue discussion in the other topic.
Previous Topic: dblink with a new server
Next Topic: duplicate service handlers while listener running
Goto Forum:
  


Current Time: Sat Dec 10 05:11:58 CST 2016

Total time taken to generate the page: 0.06016 seconds