Re: Migration from Oracle to Postgres

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