top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What causes the "snapshot too old" error?

+4 votes
55 views
What causes the "snapshot too old" error?
posted Jan 4, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
You can find too many links for this issue check this -
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:275215756923

1 Answer

0 votes

ORACLE/PLSQL: ORA-01555
Learn the cause and how to resolve the ORA-01555 error message in Oracle.

DESCRIPTION

When you encounter an ORA-01555 error, the following error message will appear:

ORA-01555: snapshot too old (rollback segment too small)
CAUSE

This error can be caused by one of the problems, as described below.

RESOLUTION

The option(s) to resolve this Oracle error are:

Option #1

This error can be the result of there being insufficient rollback segments.

A query may not be able to create the snapshot because the rollback data is not available. This can happen when there are many transactions that are modifying data, and performing commits and rollbacks. Rollback data is overwritten when the rollback segments are too small for the size and number of changes that are being performed.

To correct this problem, make more larger rollback segments available. Your rollback data for completed transactions will be kept longer.

Option #2

This error can be the result of programs not closing cursors after repeated FETCH and UPDATE statements.

To correct this problem, make sure that you are closing cursors when you no longer require them.

Option #3

This error can occur if a FETCH is executed after a COMMIT is issued.

The number of rollback records created since the last CLOSE of your cursor will fill the rollback segments and you will begin overwriting earlier records.

answer Sep 15, 2014 by Arun Gowda
Similar Questions
0 votes

I am getting 'snapshot too old error' frequently while i am running my workflow when it runs for more than 5 hrs.My source is oracle and target is Teradata. Please help to solve this issue.
Thanks in advance

+4 votes

I am unable to Open the Oracle application, java console throw an error msg:

"Oracle JInitiator version too low. Please install version 1.1.8.2 "

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...