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

From: <soumik(dot)bhattacharjee(at)kpn(dot)com>
To: <ppk10(dot)prashant(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: RE: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: 2020-04-20 11:58:42
Message-ID: 2A91BEF8171A5349931391E0C721CC53969201E9@CPEMS-KPN301.KPNCNL.LOCAL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ora2pg,Oracle Golden Gate and EDB Migration toolkit.

From: Prashant Kulkarni <ppk10(dot)prashant(at)gmail(dot)com>
Sent: maandag 20 april 2020 13:53
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

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2020-04-20 12:58:40 Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Previous Message Prashant Kulkarni 2020-04-20 11:53:18 Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL