oracle_fdw | PostgreSQL Foreign Data Wrapper for Oracle

by laurenz C Version: ORACLE_FDW_2_5_0 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(3)Vulnerabilities Install Support

kandi X-RAY | oracle_fdw Summary

oracle_fdw is a C library. oracle_fdw has no bugs, it has no vulnerabilities and it has low support. However oracle_fdw has a Non-SPDX License. You can download it from GitHub.

PostgreSQL Foreign Data Wrapper for Oracle

Support

Quality

Security

License

Reuse

Support

oracle_fdw has a low active ecosystem.

It has 411 star(s) with 143 fork(s). There are 43 watchers for this library.

It had no major release in the last 12 months.

There are 6 open issues and 531 have been closed. On average issues are closed in 56 days. There are 2 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of oracle_fdw is ORACLE_FDW_2_5_0

Quality

oracle_fdw has 0 bugs and 0 code smells.

Security

oracle_fdw has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

oracle_fdw code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

oracle_fdw has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

oracle_fdw releases are available to install and integrate.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of oracle_fdw

Get all kandi verified functions for this library.

oracle_fdw Key Features

No Key Features are available at this moment for oracle_fdw.

oracle_fdw Examples and Code Snippets

No Code Snippets are available at this moment for oracle_fdw.

Community Discussions

Trending Discussions on oracle_fdw

installing oracle_fdw without installing oracle - possible?

Identify the postgres extension version shows different versions

PostgreSQL: Create foreign table with string and variable

QUESTION

installing oracle_fdw without installing oracle - possible?

Asked 2021-Sep-16 at 19:03

I want to transfer data from remote oracle database (version 11.2) to localhost postgres (version 13) database (later to remote Postgres db, too). So, I have installed PostgreSQL 13 on my own Ubuntu 20.04.3 LTS focal and try to install oracle_fdw with this instruction. So, when trying to install Instant Client Installation for Linux x86-64 (ZIP pack; as far as I know, rpm is not available for my os configuration - no yum lib in 20.04 ubuntu focal) I follow all steps (except the last - Start your application - what does it mean?)) and when trying to execute 'make' inside oracle_fdw directory get an error

fatal error: oci.h: No such file or directory

(I download the latest development version of oracle_fdw). I found an answer of developer the oracle_fdw extension that

"If you don't have oci.h, you didn't install oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm."

but I have unzipped both instantclient-basic-linux.x64-11.2.0.4.0.zip and instantclient-sdk-linux.x64-11.2.0.4.0.zip... (for compatible with remote oracle db version 11.2)

when trying to find -name oci.h I get ./sdk/include/oci.h

My question is - Am I really have to install ORACLE on my machine? or what oracle dependencies I have to install in order to use oracle_fdw extension? Maybe my installation of oracle-instantclient is not correct (how I can test the installation of oracle-instantclient? or maybe the location for installing oracle-instantclient must be specific). P.S.: I am completely new to oracle.

Thank you!

...

ANSWER

Answered 2021-Sep-16 at 19:03

All you need is Oracle Instant Client.

If your Instant Client installation is not in one of the standard paths from the RPM distributions, just set the environment variable ORACLE_HOME to the Instant Client directory (the directory that contains sdk/include), then make should succeed.

Source https://stackoverflow.com/questions/69211052

QUESTION

Identify the postgres extension version shows different versions

Asked 2021-Jun-29 at 16:31

Have a postgres database with extensions

If I do psql>\dx it shows

...

ANSWER

Answered 2021-Jun-29 at 16:31

The first is the extension version, which changes only if the extension's objects change. The second is the version of oracle_fdw.

See the documentation:

Note that the extension version as shown by the psql command \x or the system catalog pg_available_extensions is not the installed version of oracle_fdw. To get the oracle_fdw version, use the function oracle_diag.

Source https://stackoverflow.com/questions/68182136

QUESTION

PostgreSQL: Create foreign table with string and variable

Asked 2020-Dec-02 at 09:51

My problem: I need to define foreign table dynamically and set different where conditions every time. I am doing this in function, but I am getting error which doesn't make sense to me during creation of the foreign table(via oracle_fdw).

Creation of foreign table that works:

...

ANSWER

Answered 2020-Dec-02 at 09:23

You have to use a string literal as value for a FDW option, expressions like the string concatenation you are trying to use are not allowed.

You will have to construct the complete statement with dynamic SQL, for example

Source https://stackoverflow.com/questions/65099070

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install oracle_fdw

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: