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

Поиск
Список
Период
Сортировка
От Pepe TD Vo
Тема Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL
Дата
Msg-id 956690593.227606.1587751881305@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-admin
oracle version 12.1 in linux 5.6 - production
and 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Prince Pathria
Дата:
Сообщение: Re: Help needed for replication issue
Следующее
От: Raj kumar
Дата:
Сообщение: Wal keep segment