Message-ID: <aa858bf13f52e32448216fb1b383cebe6682f4f4.camel@cybertec.at>
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format
 to migrate into PostgreSQL
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Avinash Kumar <avinash.vallarapu@gmail.com>
Cc: Pepe TD Vo <pepevo@yahoo.com>, pgsql-admin@lists.postgresql.org, Thomas
	Kellerer <shammat@gmx.net>
Date: Fri, 24 Apr 2020 16:50:30 +0200
In-Reply-To: 
 <CAN0TujdO_BJy2nvUv85Xtd49PjhaDk0UrEa8r2hVd_n5TQqjAA@mail.gmail.com>
References: 
	<CAOLrvP6sSTH2Mq5q29-9Jdk3JrR-PGT5WE+eN=8xnqKg8vnvbw@mail.gmail.com>
	 <c5b9987a-ad9e-ce37-d734-2fb38d1d7330@gmx.net>
	 <172687860.2288957.1587391373846@mail.yahoo.com>
	 <ee5a27d790ac43d4358b6353f37d09eee4214bbf.camel@cybertec.at>
	 <CAN0TujfgG8bYSjZNF0z22muF30mKawNpLtrr_pMQVqrhuk=OLQ@mail.gmail.com>
	 <aca45930c9152836c359b7f91e5f9fceab39cf43.camel@cybertec.at>
	 <231996387.101528.1587734905966@mail.yahoo.com>
	 <e212c8061d9b4aad4750660e4c3d801098f5cb82.camel@cybertec.at>
	 <CAN0TujdO_BJy2nvUv85Xtd49PjhaDk0UrEa8r2hVd_n5TQqjAA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.32.5 (3.32.5-1.fc30) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

On Fri, 2020-04-24 at 10:35 -0300, Avinash Kumar wrote:
> On Fri, Apr 24, 2020 at 10:31 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > On Fri, 2020-04-24 at 13:28 +0000, Pepe TD Vo wrote:
> > > is a foreign-data wrapper open source? 
> > 
> > Yes, see the license.
> > The page is https://laurenz.github.io/oracle_fdw/
> 
> Was it due to the tricky part of Oracle libraries linking and dependency on Oracle client that you did not plan to think of creating an RPM of it ? 
> Not sure if it was discussed before, but what was the reason for Oracle_FDW not being available in PGDG repo ?

No, but rather that there is a plethora of Linux distributions in various versions
on various architectures, and I'd have to create an RPM for any of them
(not to speak of the distributions that use other package managers).

And on Linux it is really easy to build the binaries.

About the PGDB packages, that's not for me to answer.
Perhaps it is not deemed important enough, perhaps there are technical or
license problems.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com