RA-01555: snapshot too old Urgent

[prakashs43]

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

[Sekhar]

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

[Axr2]

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.

[prakashs43]

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 ?

[prakashs43]

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