Re: Migration from Oracle to Postgres

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Migration from Oracle to Postgres
Date: 2020-05-05 10:14:08
Message-ID: 1588673648717-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter 2020-05-05 10:45:07 Re: 12.2: Howto check memory-leak in worker?
Previous Message Laurenz Albe 2020-05-05 08:23:51 Re: Installing Postgis25_11