indicated that you configured the Oracle Client wrongly.
> Usually, that is a question of setting environment variables wrong, but
> unfortunately it is a very generic error that Oracle throws when "something
> is wrong".
>
> Your best bet is to research all the oracle_fdw issues t
unfortunately it is a very generic error that Oracle throws when "something
is wrong".
Your best bet is to research all the oracle_fdw issues that reported this
error. Hopefully, one of these cases matches yours:
https://github.com/laurenz/oracle_fdw/issues?q=is%3Aissue%20OCIEnvCreate
Yours,
Laurenz Albe
Hello Team!
We are using Postgresql-15, ahd having issues importing foreign schema with
all its objects from an Oracle databse. Here is the error I am getting,
"error connecting to Oracle: OCIEnvCreate failed to create environment
handle: Detail: SQL state: HV00N
I have installed oracle instantclie
On Mon, 2021-09-20 at 15:41 +0200, Magnus Hagander wrote:
> Just as a note, with PostgreSQL 14 the FDW APIs allow batch insert. It
> should be possible to update oracle_fdw to take advantage of that as
> well, right?
Yes. The exercise is more complicated in Oracle, because they don&
-Oprindelig meddelelse-
>Fra: Laurenz Albe
>Sendt: 20. september 2021 15:18
>Til: Niels Jespersen ; pgsql-gene...@postgresql.org
>Emne: Re: Possibilities for optimizing inserts across oracle_fdw foreign data
>wrapper
>
>On Sun, 2021-09-19 at 10:28 +, Niels Jespe
On Mon, Sep 20, 2021 at 3:18 PM Laurenz Albe wrote:
>
> On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> > We are often using the oracle_fdw to transfer data between Postgres
> > (version 11+) and Oracle (version 18+). It works great.
> >
> > Howe
On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> We are often using the oracle_fdw to transfer data between Postgres (version
> 11+) and Oracle (version 18+). It works great.
>
> However I have a task at hand that requires inserting a few billion rows in
> an Orac
On 9/19/21 06:28, Niels Jespersen wrote:
Hello all
We are often using the oracle_fdw to transfer data between Postgres
(version 11+) and Oracle (version 18+). It works great.
However I have a task at hand that requires inserting a few billion
rows in an Oracle table from a Postgres query
Hello all
We are often using the oracle_fdw to transfer data between Postgres (version
11+) and Oracle (version 18+). It works great.
However I have a task at hand that requires inserting a few billion rows in an
Oracle table from a Postgres query.
insert into t_ora (a,b,c)
select a,b,c from
Thank you.
On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe
wrote:
> chiru r wrote:
> > I am trying to install and configure the oracle_fdw on PostgreSQL DB
> servers.
> > What we are trying is, inorder to install (make, make install)
> oracle_fdw on all DB servers,we want to
chiru r wrote:
> I am trying to install and configure the oracle_fdw on PostgreSQL DB servers.
> What we are trying is, inorder to install (make, make install) oracle_fdw on
> all DB servers,we want to compile on one server and want build a package/tar
> file to copy the libra
On Tue, 13 Feb 2018 at 5:55 am, chiru r wrote:
> Hi,
>
> I am trying to install and configure the oracle_fdw on PostgreSQL DB
> servers.
> What we are trying is, inorder to install (make, make install) oracle_fdw
> on all DB servers,we want to compile on one server and want bui
Hi,
I am trying to install and configure the oracle_fdw on PostgreSQL DB
servers.
What we are trying is, inorder to install (make, make install) oracle_fdw
on all DB servers,we want to compile on one server and want build a
package/tar file to copy the library files and required SQL scripts into
13 matches
Mail list logo
