Running the load in prod failed for some tables with an Oracle error. See #1956.
psycopg.errors.FdwUnableToCreateExecution: error fetching result: OCIStmtFetch2 failed to fetch next result row
DETAIL: ORA-01555: snapshot too old: rollback segment number 21 with name "_SYSSMU21_2881811878$" too small
The solution is to limit the size of each insert and update by dividing it into chunks.
Acceptance criteria
load_data_for_table() and related code modified to load data in chunks
Summary
Running the load in
prod
failed for some tables with an Oracle error. See #1956.The solution is to limit the size of each insert and update by dividing it into chunks.
Acceptance criteria
load_data_for_table()
and related code modified to load data in chunks