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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: 2020-04-20 12:58:40
Message-ID: f6317327-2d71-419c-f857-8384a912a097@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 4/20/20 6:53 AM, Prashant Kulkarni 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.

What kind of data (transaction history, binary blobs, GIS, etc)?

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2020-04-20 13:27:55 Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Previous 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