Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Arrow Unanswered: error specified index does not exist though it is exist

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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 ?
    I'll believe Oracle's error message & suggest your assessment is incorrect.
    However you provide not enough details for anyone to actually determine what you are doing wrong.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Hi,
    Thanks for replying.
    I don't know what kind of information you think might help.
    I can tell you that I'm going over my list of indexes one by one and perform the rebuild. The database is quite full and therefore this takes some time.
    There were two indexes of the same table that cause me this problem. when i tried later to run the command separately on them I got the same error.
    But when I tried even later the same command it was a success.

    This is what I know for now.

    Thanks,
    Lital

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •