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 172687860.2288957.1587391373846@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL  (Thomas Kellerer <shammat@gmx.net>)
Ответы Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Mr. Kellerer,

we can access Oracle table within Postgres?  How?  Need to create a database link and/or how can both talk to each other?

My data is from production, can turn off the foreign key.  Is there a way to copy data from Oracle to Postgres faster?  Should I export the Oracle data table via dump file as text/csv and insert it into Postgres?  Can we use an oracle dump file?

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 Monday, April 20, 2020, 09:28:18 AM EDT, Thomas Kellerer <shammat@gmx.net> wrote:


Prashant Kulkarni schrieb am 20.04.2020 um 13:53:

> Hi Team,
>
> Please can you let me know the menthds/tools/approches to export
> large amount of data (TBs) present in the schemas into the
> CSV/delimated format as we have to import that into PostgreSQL
> later.
>
> I tried for options like SQL Developer/Toad but those are not
> feasible for vast data size, these tool are OK for GBs of data to
> export.
>
> Kindly let me know if you have any solution to complete this task.


Using a foreign table would remove the need to dump and transfer
the data to begin with.

Then you could access the Oracle table directly from within Postgres:

insert into some_table (...)
select ...
from oracle_fdw_table;



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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL