From: Pepe TD Vo <pepevo@yahoo.com>
To: Jonah H. Harris <jonah.harris@gmail.com>
Cc: pgsql-admin@lists.postgresql.org, Thomas Kellerer <shammat@gmx.net>
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: Fri, 24 Apr 2020 18:11:21 +0000 (UTC)
Message-ID: <956690593.227606.1587751881305@mail.yahoo.com> (raw)
In-Reply-To: <CADUqk8XONnZWRvMUVju-B8C1FxmXxfhm=9vWKjH2OhRq6Zf-Rw@mail.gmail.com>
References: <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
<c5b9987a-ad9e-ce37-d734-2fb38d1d7330@gmx.net>
<172687860.2288957.1587391373846@mail.yahoo.com>
<CADUqk8XONnZWRvMUVju-B8C1FxmXxfhm=9vWKjH2OhRq6Zf-Rw@mail.gmail.com>
oracle version 12.1 in linux 5.6 - productionand in lab aws, oracle 12.1 as well.
Gov needs to see how can we migrate or not before approve to use postgres and move all out off oracle.
thank you
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
On Friday, April 24, 2020, 12:57:29 PM EDT, Jonah H. Harris <jonah.harris@gmail.com> wrote:
On Mon, Apr 20, 2020 at 10:03 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
Can we use an oracle dump file?
While I generally think the FDW copy is the best (and fastest) approach, I have a tool that can import Oracle export files into Postgres. What version of Oracle?
--
Jonah H. Harris
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: pepevo@yahoo.com, jonah.harris@gmail.com, shammat@gmx.net
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
In-Reply-To: <956690593.227606.1587751881305@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