Thread: 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