From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: Mon, 20 Apr 2020 07:58:40 -0500
Message-ID: <f6317327-2d71-419c-f857-8384a912a097@gmail.com> (raw)
In-Reply-To: <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
References: <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
In-Reply-To: <f6317327-2d71-419c-f857-8384a912a097@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox