RA-01555: snapshot too old Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RA-01555: snapshot too old Urgent

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    RA-01555: snapshot too old Urgent

    Hi friends

    i am uploading data from instance x to instance y
    we encountered following message

    java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 6 with name "R5" too small

    could you please suggest what i should do to remove this error . do i need to increase size of rollback segment 6 .

    this is production database

    appreciate your quick response

  2. #2
    Join Date
    Jan 2002
    Posts
    78
    Create a big rollback segment rb_seg_name ( this you can guess as per the data size you are moving)

    SET TRANSACTION USE ROLLBACK SEGMENT rb_seg_name

    Then start moving data.

    I hope the above thing works

  3. #3
    Join Date
    Oct 2002
    Posts
    807
    Originally posted by Sekhar
    I hope the above thing works
    May work. May not work.


    To Orginal poster : Read note 40689.1 on metalink. I realize that you're in a 'firefighting' mode. It is still worth spending 30minutes to read/understand the article. Scroll to the bottom for solutions.

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    hi sekhar ,


    actually java progam is executed which moves data in steps there are few comits also in between ,
    it is not from sql .

    can i assign big rollbacksegment to hava program without coding in java program ?

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi friends ,

    i see rollback segment R5 in instance "A" where data is retrieving there is no write operation in this as per my knowledge

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