Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ogg-00665 and ORA-01555: snapshot too old: rollback s egment number 3 with

user569151Jul 6 2012 — edited Jul 7 2012
One of my extracts abended with following error:

OGG-00665 OCI Error getting LOB length for table (admin.T110) column 393 (C2110001671) (status = 1555-ORA-01555: snapshot too old: rollback s
egment number 3 with name "_SYSSMU3_1278437183$" too small), SQL<SELECT x."C1",x."C2",x."C3",x."C4",x."C5",x."C6",x."C7",x."C8",x."C112",x."C536870915",x."C536870916",x."C53
6870917",x."C536870919",x."C536870922",x."C536870954",x."C536870995",x."C536870999",x."C5368>.


undo_retention already set as 86400 from a smaller number.

What should I do here?

All other extracts work fine.

Thank you
This post has been answered by stevencallan on Jul 7 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2012
Added on Jul 6 2012
1 comment
908 views