ORA-03113 trying to rebuild indexes

There are few indexes in my database, which when I tried to "rebuild" gave me an error -- ORA-03113. I have tried to rebuild them at different hours (peak and non-peak), but the same problem persists. My session disconnects. This is true with few of my indexes, not all. A query which uses these indexes takes a longer time. What could the problem be?

    Requires Free Membership to View

    Login

The ORA-3113 error is a generic error indicating that your session with the database has been severed. The most common cause of this error is a network error. You will need to be sure that your network connection to the database is not being severed for some reason.

The second most common cause of this error is an Oracle bug. You did not include an Oracle version, so I cannot verify if a bug exists and is causing your problem. Please check Metalink to see if a bug exists for your version. I would search on "ORA 3113 index rebuild" in this case. If a bug exists, Metalink will let you know which patchset or version contains the bug fix. You may have to apply a patchset or upgrade to resolve this problem.

If you cannot find a bug on Metalink, then your can file a TAR with Oracle Support. Alternatively, you may attempt to drop and recreate the index.

This was first published in June 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top