From: Virendra Kumar <viru_7683@yahoo.com>
To: Pepe TD Vo <pepevo@yahoo.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
To: Pgsql-general <pgsql-general@postgresql.org>
To: PgAdmin Support List <pgadmin-support@lists.postgresql.org>
To: JC JC <shekharjchandra@hotmail.co.uk>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Subject: Re: migrate off oracle data to postgres
Date: Tue, 31 Mar 2020 16:08:55 +0000 (UTC)
Message-ID: <380953143.257193.1585670935977@mail.yahoo.com> (raw)
In-Reply-To: <fa5af0b3-1fed-1aaf-3be3-1d2b3f385e72@aklaver.com>
References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com>
<1587437647.1103378.1585664119295@mail.yahoo.com>
<DB6PR0902MB2216EE98F1DF8368DC95A331E5C80@DB6PR0902MB2216.eurprd09.prod.outlook.com>
<1493124385.1141236.1585669895986@mail.yahoo.com>
<fa5af0b3-1fed-1aaf-3be3-1d2b3f385e72@aklaver.com>
FDW for oracle and ora2pg both are too slow compared to offload data in a file and load into PostgreSQL. When I was doing one of my migrations I found the best solution was to download data using sqlldr on to the database host where PostgreSQL instance is running and load it using COPY command.
Regards,
Virendra Kumar
On Tuesday, March 31, 2020, 8:55:17 AM PDT, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 3/31/20 8:51 AM, Pepe TD Vo wrote:
> I have tables ddl data definitions already. Only need to move the data
> over off Oracle to Postgres
PostgreSQL Foreign Data Wrapper for Oracle:
http://laurenz.github.io/oracle_fdw/
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: viru_7683@yahoo.com, pepevo@yahoo.com, pgsql-general@postgresql.org, pgadmin-support@lists.postgresql.org, shekharjchandra@hotmail.co.uk, adrian.klaver@aklaver.com
Subject: Re: migrate off oracle data to postgres
In-Reply-To: <380953143.257193.1585670935977@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox