Q

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.

This was first published in June 2005

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close