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

Поиск
Список
Период
Сортировка
От manish yadav
Тема Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL
Дата
Msg-id 1450224935.2308894.1587394618311@mail.yahoo.com
обсуждение исходный текст
Ответ на Exporting TBs of data in Oracle schema/database into CSV format tomigrate into PostgreSQL  (Prashant Kulkarni <ppk10.prashant@gmail.com>)
Список pgsql-admin
Дерево обсуждения
You may consider pgloader for copying data from csv to PostgreSQL in a faster way(in parallel)  and with explicit error details.

Thanks and Regards,

Manish Yadav



On Monday, 20 April 2020, 5:23:52 PM IST, Prashant Kulkarni <ppk10.prashant@gmail.com> wrote:


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.

Thanks.

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

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