StarTeam Purge operation fails with a ORA-01555 error

0 Likes

Problem:

StarTeam Purge operation fails with a ORA-01555 error

Resolution:

  • Product Name: StarTeam
  • Product Version: 2005 R2
  • Product Component: Server
  • Platform/OS Version: Windows

Question:

Why do I get the error ?ORA-01555:snapshot too old? when purging large amounts of data on Oracle? The StarTeam Purge operation fails.


Answer:

If a database having fewer and smaller roll back segments has many transactions that purge data and commit very often, then the chances of reusing the space used by a committed transaction is higher and hence can cause this error to occur. If using Oracle 8i, use larger roll back segments and if using Oracle 9i increase the UNDO_RETENTION setting value.


Author: Anuraj Berde

Updated: Andrew Thompson

Old KB# 27986
Comment List
Related
Recommended