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
978 stars 341 forks source link

Export data with CLOB is too slow #1796

Closed frc372 closed 1 day ago

frc372 commented 3 weeks ago

Hi, I have to do a data migration from oracle to postgres, using a Windows 10 machine. There are CLOBs data and the migration is too slow (about 10 records/sec). How can I improve it, mabye with different configuration or anything else? Thank you for your attention.

darold commented 3 weeks ago

Use the -J option or consider using the FWD capability of Ora2Pg

frc372 commented 3 weeks ago

ok thanks, and how can I use the FWD?

frc372 commented 3 weeks ago

Also, if I started using a Linux machine, would I increase this speed a lot?

darold commented 3 weeks ago

Yes, the -J or -P options, I mean multiprocess, doesn't work on Windows.

frc372 commented 2 weeks ago

good morning and how can I use the FWD in ora2pg?

darold commented 2 weeks ago

Enable and set a name to FDW_SERVER configuration directive.

frc372 commented 2 weeks ago

ok thank you for your time.