ORA-01555
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01555

  1. #1
    Join Date
    Jan 2001
    Posts
    138
    We are getting the following error:

    ERROR:
    ORA-01555: snapshot too old: rollback segment number 36 with name "R36" too small
    ORA-02063: preceding line from PROD

    The user is doing a SELECT from a View and dumping the results into a flat file. Usually it takes 3 -4 minutes to run. Now a couple of times it ranf ro almost 2 hours and errored out with the above errors. The user is coming from another database into our production database.

    Our Rollback segments sizes are fine. I thought ORA-1555 is a read consistency error.

    Any ideas? Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your rollback segments are not fine. Use the "Search Forums" link at http://www.dbasupport.com/forums/search.php

    You will find entries similar to:
    http://www.dbasupport.com/forums/sea...ily=&pagenum=1
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width