Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL

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(dot)harris(at)gmail(dot)com> wrote:

On Mon, Apr 20, 2020 at 10:03 AM Pepe TD Vo <pepevo(at)yahoo(dot)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