From: manish yadav <manishy174@yahoo.co.in>
To: pgsql-admin <pgsql-admin@postgresql.org>
To: Prashant Kulkarni <ppk10.prashant@gmail.com>
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: Mon, 20 Apr 2020 14:56:58 +0000 (UTC)
Message-ID: <1450224935.2308894.1587394618311@mail.yahoo.com> (raw)
In-Reply-To: <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
References: <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
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.
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: manishy174@yahoo.co.in, ppk10.prashant@gmail.com
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
In-Reply-To: <1450224935.2308894.1587394618311@mail.yahoo.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