Questions tagged [oracle-fdw]
The oracle-fdw tag has no usage guidance.
8
questions
1
vote
1
answer
82
views
Updating an oracle updatable view through an oracle_fdw foreign table in PostgreSQL fails with ORA-02014
I created an updatable view V1 in an Oracle 11g DB (it has INSTEAD OF triggers for UPDATE, DELETE and INSERT); it originally had a GROUP BY query in it, which I moved to another view V2. This other ...
- 406
0
votes
0
answers
109
views
Is there a way to UPSERT an Oracle Foreign Table with Foreign Data Wrapper from PostgreSQL?
I need to transfer lots of row from my PostgreSQL database to a remote Oracle DB through the Oracle Foreign Data Wrapper (FDW). The preferred way to do it is by UPSERT.
However as INSERT INTO ... ON ...
- 209
1
vote
2
answers
551
views
PostgreSQL-Patroni-Cluster: Installing oracle_fdw, dependency problem
For Oracle to PostgreSQL migrations we're currently looking into ora2pg. However, the performance using either writes to file or direct read from Oracle and write to PostgreSQL have both been very ...
- 207
0
votes
1
answer
103
views
Maintaining Postgres copies of fdw tables from Oracle
I have a production Oracle 11g server, from which I want to copy data regularly to PostgreSQL 10.14 database for DWH uses, so as not to overload the production with analytics queries.
I have ...
- 141
3
votes
1
answer
2k
views
How to UPDATE/DELETE an Oracle Foreign Table with Foreign Data Wrapper from PostgreSQL?
I need to transfer lots of row from my PostgreSQL database to a remote Oracle DB through the Oracle Foreign Data Wrapper (FDW). The required operation is so far INSERT to a Foreign Table (FT), but now ...
- 209
0
votes
1
answer
936
views
postgres fdw create foreign table without specifiy columns
need to create couple of foreign tables with a lot of columns from oracle.
I dont want to specify all cloumns by myself.
Is there a way to do something like this:
create foreign table ALFSTK **(*)** ...
- 21
3
votes
1
answer
2k
views
OCIEnvCreate failed to create environment handle after installing oracle_fdw
I'm want use Postgresql 9.3 in CentOS 7 and add extention oracle_fdw.
but when use this extenstion i get error
OCIEnvCreate failed to create environment handle after installing oracle_fdw.
my ...
4
votes
3
answers
6k
views
OCIEnvCreate failed to create environment handle after installing oracle_fdw
I have installed oracle_fdw successfully. After I create extension oracle_fdw and
foreign table it shows the following error. Is this a server configuration problem?
--env
Oracle : 10.2.0.1
...
- 1,427