{"id":9666,"date":"2019-02-21T07:47:25","date_gmt":"2019-02-21T07:47:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=9666"},"modified":"2019-11-12T07:15:01","modified_gmt":"2019-11-12T07:15:01","slug":"data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/","title":{"rendered":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors"},"content":{"rendered":"<p>When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob column. There are two main reasons for this.<\/p>\n<ul>\n<li>You can have a corruption in the lob column in the related table<\/li>\n<li>The lob retention value of the Related Table is not as it should be<\/li>\n<\/ul>\n<p>The expdp process terminates as follows.<\/p>\n<p><span style=\"color: #ff0000;\"><em>ORA-31693: Table data object &#8220;USER&#8221;.&#8221;TABLE&#8221; failed to load\/unload and is being skipped due to error:<\/em><\/span><br \/>\n<span style=\"color: #ff0000;\"><em>ORA-02354: error in exporting\/importing data<\/em><\/span><br \/>\n<span style=\"color: #ff0000;\"><em>ORA-01555: snapshot too old: rollback segment number 154 with name &#8220;_SYSSMU154_1434655980$&#8221; too small<\/em><\/span><\/p>\n<ul>\n<li>In the first case, the relevant corrections need to be corrected. Then it will be completed without errors.<\/li>\n<li>In the second case, the retention value of the lob column in the corresponding table and the value of the system&#8217;s undo_retention should be increased sufficiently.<\/li>\n<\/ul>\n<p><strong>Find the current value of undo_retention:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; show parameter undo;\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nundo_management string AUTO\nundo_retention integer 900\nundo_tablespace<\/pre>\n<p><strong>Finding the longest query&#8217;s completed time:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select max(maxquerylen) from v$undostat;\n\nMAX(MAXQUERYLEN)\n----------------\n15429<\/pre>\n<p><strong>Identify the lob retention value of the table that is causing the problem:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">SQL&gt; select retention from dba_lobs where owner='USER' and table_name='TABLE';\n\nRETENTION\n----------\n900<\/pre>\n<p>In the above example, the completed time of the longest query is 15429 seconds. The lob retention value of the table, and the value of undo_retention is 900 seconds (15 minutes).<\/p>\n<p>In this case, undo_retention should be increased and the lob retention value of the table should be equalized.<\/p>\n<p><strong>Change undo_retention:<\/strong><\/p>\n<p>The value of undo retention should be given more than the completion time of the longest query. Also make sure that there is enough undo tablespace for the value of undo_retention.<\/p>\n<pre class=\"lang:default decode:true\">SQL&gt;ALTER SYSTEM SET UNDO_RETENTION = 15500 scope=both sid='*';<\/pre>\n<p><strong>Change the lob retention of the table:<\/strong><\/p>\n<p>Undo retention value of the system and the lob retention value of the table are equalized with this change.<\/p>\n<pre class=\"lang:default decode:true\">SQL&gt; alter table USER.TABLE modify lob(LOB_COLUMN_NAME) (pctversion 5);\nTable altered.\n\nSQL&gt; alter table USER.TABLE modify lob(LOB_COLUMN_NAME) (retention);\nTable altered.<\/pre>\n<p>When we query the current lob retention value of the table, it must be the same as undo_retention.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select retention from dba_lobs where owner='USER' and table_name='TABLE';\n\nRETENTION\n----------\n15500<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9666\" class=\"pvc_stats all  \" data-element-id=\"9666\" 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>When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob column. There are two main reasons for this. You can have a corruption in the lob column in the related table The lob retention value of the Related Table is &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9666\" class=\"pvc_stats all  \" data-element-id=\"9666\" 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":1,"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":[4],"tags":[2089,2090,1716,2091,2088,699,1713,2086,2087,2093,2092,703],"class_list":["post-9666","post","type-post","status-publish","format-standard","","category-oracle","tag-change-undo_retention","tag-dba_lobs","tag-error-in-exporting-importing-data","tag-find-undo_retentition","tag-lob-retention","tag-ora-01555","tag-ora-02354","tag-ora-31693","tag-pctversion","tag-snapshot-too-old-rollback-segment-number-154-with-name-_syssmu154_1434655980-too-small","tag-table-data-object-user-table-failed-to-load-unload-and-is-being-skipped-due-to-error","tag-undo_retention"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":9101,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors\" \/>\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\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-21T07:47:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T07:15:01+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors\",\"datePublished\":\"2019-02-21T07:47:25+00:00\",\"dateModified\":\"2019-11-12T07:15:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\"},\"wordCount\":314,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"Change undo_retention\",\"dba_lobs\",\"error in exporting\/importing data\",\"find undo_retentition\",\"lob retention\",\"ORA-01555\",\"ORA-02354\",\"ORA-31693\",\"pctversion\",\"snapshot too old: rollback segment number 154 with name \\\"_SYSSMU154_1434655980$\\\" too small\",\"Table data object \\\"USER\\\".\\\"TABLE\\\" failed to load\/unload and is being skipped due to error\",\"UNDO_RETENTION\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\",\"name\":\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2019-02-21T07:47:25+00:00\",\"dateModified\":\"2019-11-12T07:15:01+00:00\",\"description\":\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials","description":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors","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\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/","og_locale":"en_US","og_type":"article","og_title":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials","og_description":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-21T07:47:25+00:00","article_modified_time":"2019-11-12T07:15:01+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors","datePublished":"2019-02-21T07:47:25+00:00","dateModified":"2019-11-12T07:15:01+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/"},"wordCount":314,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["Change undo_retention","dba_lobs","error in exporting\/importing data","find undo_retentition","lob retention","ORA-01555","ORA-02354","ORA-31693","pctversion","snapshot too old: rollback segment number 154 with name \"_SYSSMU154_1434655980$\" too small","Table data object \"USER\".\"TABLE\" failed to load\/unload and is being skipped due to error","UNDO_RETENTION"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/","name":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2019-02-21T07:47:25+00:00","dateModified":"2019-11-12T07:15:01+00:00","description":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/21\/data-pump-export-process-ends-with-ora-31693-ora-02354-and-ora-01555-errors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9666","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9666"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9666\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}