Problem solve Get help with specific problems with your technologies, process and projects.

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?

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.

Dig Deeper on Oracle error messages

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.