{"id":6200,"date":"2018-12-02T21:51:57","date_gmt":"2018-12-02T21:51:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=6200"},"modified":"2018-12-02T22:03:50","modified_gmt":"2018-12-02T22:03:50","slug":"foreign-data-wrapper-between-postgresql-and-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/","title":{"rendered":"Foreign Data Wrapper Between PostgreSQL and Oracle"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>In the article \u201c<a title=\"Postgresql Foreign Data Wrapper\" href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/22\/postgresql-foreign-data-wrapper\/\" target=\"_blank\" rel=\"noopener\">Postgresql Foreign Data Wrapper<\/a>\u201c, we created Foreign Data Wrapper to read data between two PostgreSQLs.<\/p>\n<p>And we have created Foreing Data Wrapper Between PostgreSQL and MSSQL in the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/23\/foreign-data-wrapper-between-postgresql-and-mssql\/\" target=\"_blank\" rel=\"noopener\">PostgreSQL Foreign Data Wrapper Between PostgreSQL and MSSQL<\/a>&#8220;.<\/p>\n<p>In this article, we will create Foreign Data Wrapper between PostgreSQL and Oracle.<\/p>\n<h3>PREPARATION:<\/h3>\n<p>When installing Oracle Foreign Data Wrapper, we need to install oracle instant client.<\/p>\n<p>In the instant client, we need to install the following rmps;<\/p>\n<p>instantclient-basic_linux,<br \/>\ninstantclient_sdk_linux,<br \/>\ninstantclient_sqlplus<\/p>\n<p>For installation, please refer to the article titled &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/27\/how-to-install-oracle-client-for-postgresql-on-centos\/\" target=\"_blank\" rel=\"noopener\">How To Install Oracle Client For PostgreSQL On Centos<\/a>&#8220;.<\/p>\n<p>If you have a standard installation on Postgresql, you should download and install postgresql-devel and postresql-lib rpm packages according to your version.<\/p>\n<p>After downloading and installing the required oracle_client version, you can install oracle_fdw by following the steps below.<\/p>\n<p>First we download the Oracle_fdw extension, you can use the link below to download.<\/p>\n<p>https:\/\/github.com\/laurenz\/oracle_fdw<\/p>\n<p>After downloading Oracle_fdw extension files and transferring them to any folder on our machine, we go the folder and execute the following command.<\/p>\n<pre class=\"lang:default decode:true \">make<\/pre>\n<p>After running this command, the result should return as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\" width=\"599\" height=\"455\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You may receive errors as follows when you run this command. You can find solutions to these errors in the following articles.<\/p>\n<p>&#8220;<a title=\"make: gcc : Command not found make:*** [oracle_fdw.o] Error 127\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/25\/make-gcc-command-not-found-make-oracle_fdw-o-error-127\/\" target=\"_blank\" rel=\"noopener\">make: gcc : Command not found make:*** [oracle_fdw.o] Error 127&#8243;<\/a>,<\/p>\n<p>&#8220;<a title=\"Oracle_fdw oracle_utils.c:22:17: fatal error: oci.h: No such file or directory\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/21\/oracle_fdw-oracle_utils-c2217-fatal-error-oci-h-no-such-file-or-directory\/\" target=\"_blank\" rel=\"noopener\">Oracle_fdw oracle_utils.c:22:17: fatal error: oci.h: No such file or directory&#8221;<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>After the above operation is completed, you can continue by running the next command.<\/p>\n<pre class=\"lang:default decode:true \">\u00a0make install<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_3.png\" width=\"623\" height=\"121\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Finally, we execute the following command and our operations at the operating level are completed.<\/p>\n<p>The purpose of this process is to compile the PostgreSQL code and the oracle_fdw code together.<\/p>\n<pre class=\"lang:default decode:true \">make NO_PGXS=1<\/pre>\n<p>&nbsp;<\/p>\n<h3>CREATE EXTENSION:<\/h3>\n<p>After connecting to postgres with psql, we run the following command to create the extension.<\/p>\n<pre class=\"lang:default decode:true \">create extension oracle_fdw;<\/pre>\n<p>&nbsp;<\/p>\n<h3>CREATE SERVER:<\/h3>\n<p>After the extension is installed, we create the server as in other extension installations.<\/p>\n<pre class=\"lang:default decode:true \">CREATE SERVER oradb1 FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver 'oracle_ip:1521');<\/pre>\n<p>&nbsp;<\/p>\n<h3>USER MAPPING:<\/h3>\n<p>We create user mapping.<\/p>\n<pre class=\"lang:default decode:true\">CREATE USER MAPPING FOR pguser SERVER oradb1 OPTIONS (USER 'oracleuser', PASSWORD 'OracleUserPassword');<\/pre>\n<p>&nbsp;<\/p>\n<h3>CREATE FOREIGN TABLE:<\/h3>\n<p>And finally, we create a foreign table.<\/p>\n<pre class=\"lang:default decode:true \">CREATE FOREIGN TABLE ftbl_ora_test1\r\n\u00a0(\r\n\u00a0id int OPTIONS (key 'true') NOT NULL,\r\n\u00a0item varchar(10),\r\n\u00a0upd_date timestamp\r\n\u00a0)\r\n\u00a0SERVER oradb1 OPTIONS (SCHEMA 'oracle_schema', TABLE 'oracle_table');<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6200\" class=\"pvc_stats all  \" data-element-id=\"6200\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; In the article \u201cPostgresql Foreign Data Wrapper\u201c, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data Wrapper Between PostgreSQL and MSSQL in the article named &#8220;PostgreSQL Foreign Data Wrapper Between PostgreSQL and MSSQL&#8220;. In this article, we will create Foreign Data Wrapper between PostgreSQL and Oracle. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6200\" class=\"pvc_stats all  \" data-element-id=\"6200\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-6200","post","type-post","status-publish","format-standard","","category-postgres"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Foreign Data Wrapper Between PostgreSQL and Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Foreign Data Wrapper Between PostgreSQL and Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-02T21:51:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-02T22:03:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Foreign Data Wrapper Between PostgreSQL and Oracle\",\"datePublished\":\"2018-12-02T21:51:57+00:00\",\"dateModified\":\"2018-12-02T22:03:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\"},\"wordCount\":358,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\",\"name\":\"Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\",\"datePublished\":\"2018-12-02T21:51:57+00:00\",\"dateModified\":\"2018-12-02T22:03:50+00:00\",\"description\":\"Foreign Data Wrapper Between PostgreSQL and Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage\",\"url\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\",\"contentUrl\":\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Foreign Data Wrapper Between PostgreSQL and Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials","description":"Foreign Data Wrapper Between PostgreSQL and Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials","og_description":"Foreign Data Wrapper Between PostgreSQL and Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-02T21:51:57+00:00","article_modified_time":"2018-12-02T22:03:50+00:00","og_image":[{"url":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png","type":"","width":"","height":""}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Foreign Data Wrapper Between PostgreSQL and Oracle","datePublished":"2018-12-02T21:51:57+00:00","dateModified":"2018-12-02T22:03:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/"},"wordCount":358,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage"},"thumbnailUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/","name":"Foreign Data Wrapper Between PostgreSQL and Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage"},"thumbnailUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png","datePublished":"2018-12-02T21:51:57+00:00","dateModified":"2018-12-02T22:03:50+00:00","description":"Foreign Data Wrapper Between PostgreSQL and Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#primaryimage","url":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png","contentUrl":"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2018\/11\/Oracle_fdw_2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Foreign Data Wrapper Between PostgreSQL and Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6200"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6200\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}