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

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic: dblink with a new server
Next Topic: duplicate service handlers while listener running
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 09:20:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.