search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
991 stars 342 forks source link

ora2pg Data Migration Issues #1609

Closed sandeepkandhway closed 1 year ago

sandeepkandhway commented 1 year ago

I was testing data migration using ora2pg utility (v 23.2) and encountered the below issue:

# ora2pg -t COPY -o data.sql -b ./data -c ./config/ora2pg.conf -J 2
[========================>] 68088/67890 rows (100.3%) Table RLSE_ORD_AUD_T (3 sec., 22696 recs/sec)
[========================>] 118751/118751 rows (100.0%) Table RLSE_ORD_AUD_T_BACKUP (4 sec., 29687 recs/sec)
[========================>] 1/1 rows (100.0%) Table RLSE_ORD_DOC_TYP_T (0 sec., 1 recs/sec)
[========================>] 2771/2719 rows (101.9%) Table RLSE_ORD_FILE_T (30 sec., 92 recs/sec)
**[======================>  ] 41/44 rows (93.2%) Table RLSE_ORD_SHP_DTL_T (1 sec., 41 recs/sec)**
**[========================>] 13/12 rows (108.3%) Table SETTINGS_T (0 sec., 13 recs/sec)**
[========================>] 0/0 rows (100.0%) Table SHP_NODE_GRP_LCK_T (0 sec., 0 recs/sec)
[========================>] 991/991 rows (100.0%) Table SHP_NODE_T (0 sec., 991 recs/sec)
[========================>] 4440/4297 rows (103.3%) Table STK_ORD_DWNLD_T (48 sec., 92 recs/sec)

As I can see above there are several rows where the import has happened more than 100% and some less. How to troubleshoot such scenarios and ensure that no data is missed while importing data to the target postgres database.

Thanks.

sandeepkandhway commented 1 year ago

We are good with this now.