-
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
-
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
-
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.
-
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 ?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|