Date: Tue, 21 Apr 2020 10:27:55 +0200
From: "Peter M. Groen" <peter@osdev.nl>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format
 to migrate into PostgreSQL
Message-ID: <20200421102755.75308e29@optiplex64.osdev.nl>
In-Reply-To: 
 <2A91BEF8171A5349931391E0C721CC53969201E9@CPEMS-KPN301.KPNCNL.LOCAL>
References: 
 <CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
	<2A91BEF8171A5349931391E0C721CC53969201E9@CPEMS-KPN301.KPNCNL.LOCAL>
Organization: Open Systems Development
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Precedence: bulk

Actually we have something that is called the "ModelMapper" and is used
for large amounts of data transports between databases and even
different database models and this is part of our "Caelus" software
infrastructure.

Contact us for more information.

-- 
Open Systems Development B.V.
Peter M. Groen ( Managing Director )
Rooseveltstraat 18P
2321 BM  Leiden
Email : peter@osdev.nl


On Mon, 20 Apr 2020 11:58:42 +0000, soumik.bhattacharjee@kpn.com wrote:

>Ora2pg,Oracle Golden Gate and EDB Migration toolkit.
>
>From: Prashant Kulkarni <ppk10.prashant@gmail.com>
>Sent: maandag 20 april 2020 13:53
>To: pgsql-admin <pgsql-admin@postgresql.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.