Migration from Oracle to Postgres

Hi Jean Claude,

On 05. May, 2020, at 09:07, Jean Claude <jeancld38@gmail.com> wrote:

Hi guys,

I hope you're doing well.

Simple question
What are the best methods to migrate a huge table from Oracle to Postgres ?

Cheers

my colleague uses ora2pg. Though I've never tried it myself, he says, it works pretty well.

https://github.com/darold/ora2pg

Cheers,
Paul

Jean Claude wrote

Hi guys,

I hope you're doing well.

Simple question
What are the best methods to migrate a huge table from Oracle to Postgres
?

Cheers

Hello,

Depending on the datatype, and if the databases are co-located on the same
server,
you may try oracle_fdw (except for lobs, where it is slow)
or a sqlplus extract from Oracle, then load using copy command in
PostgreSQL;

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html