Quick Links

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

From:	Prashant Kulkarni <ppk10(dot)prashant(at)gmail(dot)com>
To:	pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject:	Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date:	2020-04-20 11:53:18
Message-ID:	CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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.

Responses

RE: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL at 2020-04-20 11:58:42 from soumik.bhattacharjee
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL at 2020-04-20 12:58:40 from Ron
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL at 2020-04-20 13:27:55 from Thomas Kellerer
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL at 2020-04-20 14:56:58 from manish yadav
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL at 2020-04-21 10:43:21 from pinker

Browse pgsql-admin by date

	From	Date	Subject
Next Message	soumik.bhattacharjee	2020-04-20 11:58:42	RE: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Previous Message	Wim Bertels	2020-04-20 09:25:37	Re: View pervious versions of row