Re: Migration from Oracle to Postgres - Mailing list pgsql-general

From legrand legrand
Subject Re: Migration from Oracle to Postgres
Date
Msg-id 1588673648717-0.post@n3.nabble.com
Whole thread Raw
In response to Migration from Oracle to Postgres  (Jean Claude <jeancld38@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Installing Postgis25_11
Next
From: Peter
Date:
Subject: Re: 12.2: Howto check memory-leak in worker?