Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Meaning of "snapshot too old" error doing SQL query

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Do you know what error message "snapshot too old: rollback segment number 2 with name 'R01' too small" means?

    Testing an old SQL covering both uea50 and uea01, with a couple of factors added since the last time I ran this (line 4, and the z13_year in line 1) - previously, this took ca. 15 mins. to run but did get there in the end.

    SQL-UEA50> select distinct z30_collection,substr(z30_call_no,1,15),substr(z30_barcode,1,9),substr(uea01 .z13.z13_author,1,30),substr(uea01.z13.z13_title,1,100),uea01.z13.z13_year 2 from uea50.z30,uea50.z103,uea01.z13 3 where z30_call_no like '

    This error message has no impact in the system.
    It means that at the time you tried your SQL query, Oracle must have been busy. The "rollback segments" are the place where Oracle backs up its transactions. If either you have a transaction with many records (which isn't the case here) or Oracle has many transactions at the same time, you get this error.
    You can try this again and if this does not work this time then there are ways to increase the size of these segments. (See KB 8192-2519.)

    Additional Information

    Oracle, rollback, segment, snapshot, old

    • Article last edited: 10/8/2013