{"id":39644,"date":"2022-04-20T16:01:14","date_gmt":"2022-04-20T16:01:14","guid":{"rendered":"https:\/\/dbtut.com\/?p=39644"},"modified":"2022-04-20T16:02:12","modified_gmt":"2022-04-20T16:02:12","slug":"how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/","title":{"rendered":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg"},"content":{"rendered":"<p>In today&#8217;s article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg.<\/p>\n<p>Before migrating data, I will explain ora2pg installation.<\/p>\n<h4>Ora2pg<\/h4>\n<p>It is a tool used to switch from Oracle database to Postgresql.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/miro.medium.com\/max\/1062\/1*oJIBe4LtuoVR87mStbtJnw.png\" \/><\/p>\n<p>First of all, we will install Oracle 19C Client on Oracle Linux 7. For this, we need to download the rpm packages required and put them on our server. After installing the rpm packages on our server, we run the following commands.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb]# rpm -ivh \/tmp\/oracle-instantclient19.11-basic-19.11.0.0.0-1.x86_64.rpm \r\n[root@testdb]# rpm -ivh \/tmp\/oracle-instantclient19.11-devel-19.11.0.0.0-1.x86_64.rpm \r\n[root@testdb]# rpm -ivh \/tmp\/oracle-instantclient19.11-jdbc-19.11.0.0.0-1.x86_64.rpm  \r\n[root@testdb]# rpm -ivh \/tmp\/oracle-instantclient19.11-sqlplus-19.11.0.0.0-1.x86_64.rpm<\/pre>\n<p>We install the required perl packages.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb]# yum install perl-DBD-Pg perl perl-devel perl-DBI perl-CPAN -y<\/pre>\n<p>We download the DBI module required for Perl by following the steps below.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb]#mkdir install\r\n[root@testdb]#cd install\r\n[root@testdb install]# wget https:\/\/www.cpan.org\/modules\/by-module\/DBI\/DBI-1.643.tar.gz\r\n[root@testdb install]# tar xvzf DBI-1.643.tar.gz\r\n[root@testdb install]# cd DBI-1.643\r\n[root@testdb DBI-1.643]#perl Makefile.PL\r\n[root@testdb DBI-1.643]#make\r\n[root@testdb DBI-1.643]#make install<\/pre>\n<p>We install the Oracle database driver for the DBI module by following the steps below.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ~]# export ORACLE_HOME=\/usr\/lib\/oracle\/19.11\/client64\/bin\r\n[root@testdb ~]# export LD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/lib\r\n[root@testdb ~]# export PATH=$PATH:$ORACLE_HOME\/bin\r\n[root@testdb ~]# perl -MCPAN -e shell\r\n. . . . . .\r\nWould you like me to configure as much as possible automatically? [yes]\r\n. . . . . .\r\ncpan[1]&gt; get DBD::Oracle\r\n. . . . . .\r\ncpan[2]&gt; quit\r\n[root@testdb ~]# cd ~\/.cpan\/build\/DBD-Oracle-1.80-D5Y0lj\/\r\n[root@testdb DBD-Oracle-1.80-D5Y0lj]# perl Makefile.PL\r\n[root@testdb DBD-Oracle-1.80-D5Y0lj]# make\r\n[root@testdb DBD-Oracle-1.80-D5Y0lj]# make install<\/pre>\n<p>We install the Postgres database driver for the DBI module. (DBD-Pg)<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ~]# cd install\r\n[root@testdb install]# rm -rf *\r\n[root@testdb install]# wget https:\/\/cpan.metacpan.org\/authors\/id\/T\/TU\/TURNSTEP\/DBD-Pg-3.14.2.tar.gz\r\n[root@testdb install]# tar xvzf DBD-Pg-3.10.0.tar.gz\r\n[root@testdb install]# cd DBD-Pg-3.10.0\r\n[root@testdb DBD-Pg-3.14.2]# perl Makefile.PL\r\n[root@testdb DBD-Pg-3.14.2]# make\r\n[root@testdb DBD-Pg-3.14.2]# make install<\/pre>\n<p>After completing the above steps, we can proceed to the Ora2pg installation. We will follow the steps below to install Ora2pg.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ~]# cd install\r\n[root@testdb install]# rm -rf *\r\n[root@testdb install]# wget https:\/\/sourceforge.net\/projects\/ora2pg\/files\/21.1\/ora2pg-21.1.tar.bz2\r\n[root@testdb install]# bzip2 -d ora2pg-20.0.tar.bz2\r\n[root@testdb install]# tar xvf ora2pg-20.0.tar\r\n[root@testdb install]# cd ora2pg-20.0\r\n[root@testdb ora2pg-21.0]# perl Makefile.PL\r\n[root@testdb ora2pg-21.0]# make &amp;&amp; make install<\/pre>\n<p>After the installation is complete, we need to make some changes to the ora2pg.conf file. For this, we first backup the ora2pg.conf file and make the changes. For example, since I will carry the HR chart, I will write HR in the SCHEMA section.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ~]# cd \/etc\/ora2pg\/\r\n[root@testdb ora2pg]# cp ora2pg.conf.dist ora2pg.conf\r\n--ora2pg.conf dosyas\u0131nda gerekli ayarlamalar yap\u0131l\u0131r.\r\n[root@testdb ora2pg]# vi ora2pg.conf\r\nORACLE_HOME \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\r\n#If you use SID\r\nORACLE_DSN dbi:Oracle:host=testdb.localdomain;sid=orcl;port=1521\r\n#If you use service name\r\nORACLE_DSN dbi:Oracle:\/\/localhost:1521\/orcl\r\nORACLE_USER &lt;username&gt;\r\nORACLE_PWD &lt;password&gt;\r\nTYPE              TABLE VIEW GRANT COPY\r\nOUTPUT                    output.sql\r\n# Oracle schema\/owner to use\r\nSCHEMA    HR\r\nPG_SCHEMA                hr\r\n# Export Oracle schema to PostgreSQL schema\r\nEXPORT_SCHEMA      1<\/pre>\n<p>We run the following command to see that the installation has completed successfully.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ora2pg]# ora2pg -t SHOW_VERSION -c ora2pg.conf\r\nOracle Database 19c Enterprise Edition Release 19.3.0.0<\/pre>\n<h4>Data Migration from Oracle to Postgresql:<\/h4>\n<p>After completing the configuration, we create the database and schema that we will transfer in postgres.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.2$ psql\r\npostgres=# CREATE DATABASE orcl;\r\nCREATE DATABASE\r\npostgres=# \\c orcl\r\nYou are now connected to database \"orcl\" as user \"postgres\".\r\norcl=# CREATE SCHEMA hr;\r\nCREATE SCHEMA<\/pre>\n<p>After creating the database and schema, we create the output files to move the data in the Oracle database to the postgres database by running the following command.<\/p>\n<pre class=\"lang:default decode:true \">[root@testdb ora2pg]# ora2pg -d<\/pre>\n<p>After the process is finished, data is transferred to the Postgres database using output files.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.2$ psql -U postgres -d orcl &lt; TABLE_output.sql\r\n-bash-4.2$ psql -U postgres -d orcl &lt; GRANT_output.sql\r\n-bash-4.2$ psql -U postgres -d orcl &lt; VIEW_output.sql\r\n-bash-4.2$ psql -U postgres -d orcl &lt; COPY_output.sql<\/pre>\n<p>After the data migration is complete, we can connect to the orcl database and query the tables in the hr schema.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.2$ psql\r\npostgres=# \\c orcl\r\norcl=# \\dt\r\n            List of relations\r\n Schema |    Name     | Type  |  Owner\r\n--------+-------------+-------+----------\r\n hr     | countries   | table | postgres\r\n hr     | departments | table | postgres\r\n hr     | employees   | table | postgres\r\n hr     | job_history | table | postgres\r\n hr     | jobs        | table | postgres\r\n hr     | locations   | table | postgres\r\n hr     | regions     | table | postgres\r\n(7 rows)\r\n******************************\r\norcl=# select * from countries;\r\ncountry_id |       country_name       | region_id\r\n------------+--------------------------+-----------\r\n AR         | Argentina                |         2\r\n AU         | Australia                |         3\r\n BE         | Belgium                  |         1\r\n BR         | Brazil                   |         2\r\n CA         | Canada                   |         2\r\n CH         | Switzerland              |         1\r\n(6 rows)<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_39644\" class=\"pvc_stats all  \" data-element-id=\"39644\" 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>In today&#8217;s article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg installation. Ora2pg It is a tool used to switch from Oracle database to Postgresql. First of all, we will install Oracle 19C Client on Oracle Linux 7. For this, we need &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_39644\" class=\"pvc_stats all  \" data-element-id=\"39644\" 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":3068,"featured_media":39660,"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":[4],"tags":[],"class_list":["post-39644","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3385,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.\" \/>\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\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-20T16:01:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-20T16:02:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"811\" \/>\n\t<meta property=\"og:image:height\" content=\"348\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Melek Durdu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melek Durdu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\"},\"author\":{\"name\":\"Melek Durdu\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b\"},\"headline\":\"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg\",\"datePublished\":\"2022-04-20T16:01:14+00:00\",\"dateModified\":\"2022-04-20T16:02:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\"},\"wordCount\":308,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\",\"name\":\"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg\",\"datePublished\":\"2022-04-20T16:01:14+00:00\",\"dateModified\":\"2022-04-20T16:02:12+00:00\",\"description\":\"In today's article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg\",\"width\":811,\"height\":348},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg\"}]},{\"@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\/f9c7aff3fe68fef0255caa38a944ce4b\",\"name\":\"Melek Durdu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"caption\":\"Melek Durdu\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials","description":"In today's article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.","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\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/","og_locale":"en_US","og_type":"article","og_title":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials","og_description":"In today's article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.","og_url":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/","og_site_name":"Database Tutorials","article_published_time":"2022-04-20T16:01:14+00:00","article_modified_time":"2022-04-20T16:02:12+00:00","og_image":[{"width":811,"height":348,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg","type":"image\/jpeg"}],"author":"Melek Durdu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Melek Durdu","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/"},"author":{"name":"Melek Durdu","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b"},"headline":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg","datePublished":"2022-04-20T16:01:14+00:00","dateModified":"2022-04-20T16:02:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/"},"wordCount":308,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/","url":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/","name":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg","datePublished":"2022-04-20T16:01:14+00:00","dateModified":"2022-04-20T16:02:12+00:00","description":"In today's article, I will tell you How To Migrate Data From Oracle To PostgreSQL Using Ora2pg. Before migrating data, I will explain ora2pg.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-19.jpg","width":811,"height":348},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/20\/how-to-migrate-data-from-oracle-to-postgresql-using-ora2pg\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Migrate Data From Oracle To PostgreSQL Using Ora2pg"}]},{"@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\/f9c7aff3fe68fef0255caa38a944ce4b","name":"Melek Durdu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","caption":"Melek Durdu"},"url":"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/39644","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\/3068"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=39644"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/39644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/39660"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=39644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=39644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=39644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}