Ask the Expert

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: