DBA Tips

Blog for Oracle/Postgres Database Administrators

Pages

  • Home
  • AI
  • Postgres
  • Oracle
  • MSSQL
  • Backup
  • About

Wednesday, October 5, 2022

Connecting PostgreSQL to an Oracle database (oracle_fdw)

PostgreSQL provides foreign data wrappers (FDW) as a mechanism for accessing various external data sources. 
This article explains how to access Oracle databases using oracle_fdw, a foreign data wrapper for Oracle databases.
- October 05, 2022
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

Search This Blog

Recent projects

  • Oracle
    • Creating copies of databases based on ACFS snapshots
    • Enable Fast-Start-Failover Data Guard Broker (in Zero Data Loss Mode) with OBSERVER
    • Two ways to recover data in an Oracle database table containing corruption blocks
  • Postgres
    • PostgreSQL14 HA with Patroni 2.1, Etcd, Haproxy, Keepalived (EL8)
    • Backup PostgreSQL with Barman
    • Connecting PostgreSQL to an Oracle database (oracle_fdw)
    • How to migrate data from Oracle to PostgreSQL using Ora2pg
    • Creating a replication schemas Postgres-> [Postgres &Oracle] using Oracle GoldenGate
    • Migration of Oracle database to Postgres with minimum downtime using Oracle GoldenGate
  • MSSQL
    • Copy SQL Logins by assigning roles and permissions
  • Backup
    • Netbackup tips

About Me

My photo
Roman Grishchenko
Blog for Oracle/Postgres Database Administrators
View my complete profile
Sunower. Powered by Blogger.