Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format
 to migrate into PostgreSQL
To: pgsql-admin@lists.postgresql.org
References: 
 <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <c5b9987a-ad9e-ce37-d734-2fb38d1d7330@gmx.net>
Date: Mon, 20 Apr 2020 15:27:55 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Prashant Kulkarni schrieb am 20.04.2020 um 13:53:
> 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.

Using a foreign table would remove the need to dump and transfer
the data to begin with.

Then you could access the Oracle table directly from within Postgres:

insert into some_table (...)
select ...
from oracle_fdw_table;