Home
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software
Latest
Popular
Who's Online
We have 131 guests online

ORA-01555 "snapshot too old" Print E-mail

How to avoid ORA-01555 “snapshot too old" error?

From the developer's perspective:

Restructure your PL/SQL code to avoid fetching across commits that cause the ORA-01555 error.

One possible reason can be if we leave the cursor open for fetching while
we are processing and committing data changes for a long time.


To eliminate this error completely-you need to modify the code in the following manner:
1. Opens the cursor.
2. Fetches the whole cursor into the collection (no data manipulation/committing here).
3. Closes the cursor.
4. Loops through the collection, processes the data, and commits.

From the DBA's perspective:

Avoid error by allocating rollback segments and configuring them with proper parameter values.
 

For example see: http://www.devx.com/getHelpOn/10MinuteSolution/16600

< Previous   Next >



Polls
Have you visited this site earlier?
  
gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org