migrate off oracle data to postgres

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-general <pgsql-general(at)postgresql(dot)org>, PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: migrate off oracle data to postgres
Date: 2020-03-31 14:15:19
Message-ID: 1587437647.1103378.1585664119295@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-general

Hello,
I have a huge data on Oracle, would you please suggest how to migrate all data off Oracle to Postgres?  Do I need to export into csv and upload to postgres?  Ora2pg is limited data from oracle to postgresql right?

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres
Previous Message J Paz 2020-03-31 06:16:47 RE: ASC files not verifying Windows pgAdmin 4 installers

Browse pgsql-admin by date

  From Date Subject
Next Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres
Previous Message Michael Paquier 2020-03-30 23:52:44 Re: PG12 autovac issues

Browse pgsql-general by date

  From Date Subject
Next Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres
Previous Message Laurenz Albe 2020-03-31 12:33:55 Re: Using compression on TCP transfer