-
-
Notifications
You must be signed in to change notification settings - Fork 95
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Oracle to postgres data sync issue #8
Comments
Hello, ud20, This is a common error with Oracle with large tables. Check if you can make any of the recommendations listed on this website: https://blog.enmotech.com/2018/09/10/ora-01555-snapshot-old-error-ways-to-avoid-ora-01555-snapshot-too-old-error/ In parallel I am investigating how to address it directly with ReplicaDB. Greetings |
Hello @osalvador |
Thanks to you @ud20! I keep the issue open until I find a solution to this problem directly in ReplicaDB. Regards! |
We are trying to do a data dump from oracle to postgres. On some larger tables(>120GB) we are seeing some errors.
ERROR ReplicaTask:72 ERROR in TaskId-0 inserting data to sink table: ORA-01555: snapshot too old: rollback segment number 20 with name "_SYSSMU20_231399234$" too small
We tried a few different things like, do it when the data is not changing constantly, smaller fetch size, less number of jobs running but, nothing seemed to work so far.
Did you ever see anything similar happening?
The text was updated successfully, but these errors were encountered: