{"id":14559,"date":"2021-07-12T14:30:59","date_gmt":"2021-07-12T17:30:59","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=14559"},"modified":"2021-07-12T14:43:21","modified_gmt":"2021-07-12T17:43:21","slug":"tranportable-tablespace-to-lower-release-is-it-possible","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/","title":{"rendered":"Tranportable Tablespace to lower release? Is it possible?"},"content":{"rendered":"<p>Today my experiment will be trying to run a transportable tablespace to a lower release. The reason for this experiment is to evaluate a possible fast fallback plan in case I want to roll back a migration+upgrade (eg: 12c NON-CDB to 19c PDB).<\/p>\n<p>The first important thing to note is that the non-cdb to pdb conversion is not reversible. So that&#8217;s why I plan to use transportable tablespaces as my fallback strategy here.<\/p>\n<p>However, before we start, if we check <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=291024.1\" target=\"_blank\" rel=\"noopener\"><strong>Compatibility and New Features when Transporting Tablespaces with Export and Import (Doc ID 291024.1)<\/strong><\/a>, Oracle states:<\/p>\n<table>\n<tbody>\n<tr>\n<td style=\"width: 749px; border-style: solid; border-color: #000000;\">While a transport tablespace to a lower release <strong>may work in some cases, it is not an action that Oracle supports<\/strong>. In some cases, it is possible to transport a tablespace from a higher release and plug it in a database with a lower release. Besides the standard compatibility restrictions for a &#8216;normal&#8217; export and import (export with the lower release export utility that connects to the higher database via Oracle Net), the compatibility setting of the source and target database should also match. Even if all restrictions are met, errors might occur. In those cases, these errors should not be considered as a bug.<br \/>\nExamples:<\/p>\n<ul>\n<li>a transport tablespace from Oracle9i (9.2.0.4) to Oracle8i (8.1.7.4) will fail due to not-a-bug:<br \/>\n<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/BugDisplay?parent=DOCUMENT&amp;sourceId=291024.1&amp;id=3380564\" target=\"_blank\" rel=\"noopener\">Bug:3380564<\/a>\u00a0&#8220;EXP-8 ORA-6550 PLS-306 WITH TRANSPORTABLE TABLESPACES WHEN EXPORTING 9I USING 8I&#8221;;<\/li>\n<li>a transport tablespace from Oracle10g (10.1.0.3) to Oracle10g (10.1.0.2) will fail due to not-a-bug:<br \/>\n<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/BugDisplay?parent=DOCUMENT&amp;sourceId=291024.1&amp;id=3900320\" target=\"_blank\" rel=\"noopener\">Bug:3900320<\/a>\u00a0&#8220;CANNOT TRANSPORT TABLESPACES BETWEEN 10.1.0.3 AND 10.1.0.2&#8221;<\/li>\n<\/ul>\n<p>In those cases, use the conventional export and import instead, i.e.:<\/p>\n<ul>\n<li>run a full database export (FULL=Y), or:<\/li>\n<li>run a tablespace level export (TABLESPACES=xxx,yyy), or:<\/li>\n<li>run a user-level export (OWNER=uuu,vvv), or:<\/li>\n<li>run a table-level export (TABLES=sss,ttt).<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>So it&#8217;s not supported. <span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\"><strong>Period<\/strong><\/span><\/span>. But what happens if I insist?<\/p>\n<p><strong>My playground will be:<\/strong><\/p>\n<ul>\n<li><strong>Source DB (19.11.0):<\/strong>\n<ul>\n<li>19.11 RU + 19.11.0.0.210420 OJVM<\/li>\n<li>COMPATIBLE: 12.1.0.2.0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>Target DB 1 (12.1.0.2):<\/strong>\n<ul>\n<li>12.1.0.2.210420 PSU + 12.1.0.2.210420 OJVM<\/li>\n<li>COMPATIBLE: 12.1.0.2.0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>Target DB 2 (11.2.0.4):<\/strong>\n<ul>\n<li>11.2.0.4.210420 PSU + 11.2.0.4.210420 OJVM<\/li>\n<li>COMPATIBLE: 11.2.0.4.0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4><span style=\"text-decoration: underline;\">Preparing my source environment<\/span><\/h4>\n<p>In my 19c source system, I will create some user data, so I can check them later after the migration.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 9 16:50:11 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.11.0.0.0\r\n\r\nSQL&gt; show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\nSQL&gt; alter session set container=PDB01;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select tablespace_name from dba_tablespaces;\r\n\r\nTABLESPACE_NAME\r\n------------------------------\r\nSYSTEM\r\nSYSAUX\r\nUNDOTBS1\r\nTEMP\r\n\r\nSQL&gt; CREATE TABLESPACE TOOLS DATAFILE '\/u01\/app\/oracle\/oradata\/CDB19C\/PDB01\/tools01.dbf' size 10M;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; CREATE USER TEST IDENTIFIED BY \"oracle\";\r\n\r\nUser created.\r\n\r\nSQL&gt; GRANT DBA TO TEST;\r\n\r\nGrant succeeded.\r\nSQL&gt; CREATE TABLE TEST.T1 TABLESPACE TOOLS AS SELECT * FROM DBA_USERS;\r\n\r\nTable created.\r\n\r\nSQL&gt; ALTER TABLESPACE TOOLS READ ONLY;\r\n\r\nTablespace altered.\r\n\r\nSQL&gt;<\/pre>\n<h4>1. Trying to expdp for transportable using &#8220;version&#8221; parameter for 11g\/12c.<\/h4>\n<p>Trying first with 12c as my target:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@odbfcl-19-0-0-0 ~]$ expdp \\\"sys\/Rodrigo.123@localhost:1521\/pdb01 as sysdba\\\" transport_tablespaces=tools version=12.1.0.2\r\n\r\nExport: Release 19.0.0.0.0 - Production on Mon Jul 12 14:32:49 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nStarting \"SYS\".\"SYS_EXPORT_TRANSPORTABLE_01\":  \"sys\/********@localhost:1521\/pdb01 AS SYSDBA\" transport_tablespaces=tools version=12.1.0.2\r\nProcessing object type TRANSPORTABLE_EXPORT\/STATISTICS\/TABLE_STATISTICS\r\nProcessing object type TRANSPORTABLE_EXPORT\/STATISTICS\/MARKER\r\nProcessing object type TRANSPORTABLE_EXPORT\/PLUGTS_BLK\r\nProcessing object type TRANSPORTABLE_EXPORT\/POST_INSTANCE\/PLUGTS_BLK\r\nProcessing object type TRANSPORTABLE_EXPORT\/TABLE\r\nMaster table \"SYS\".\"SYS_EXPORT_TRANSPORTABLE_01\" successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is:\r\n  \/u01\/app\/oracle\/admin\/cdb19c\/dpdump\/C6EE6CF0FB6D51D7E0536C01000AA811\/expdat.dmp\r\n******************************************************************************\r\nDatafiles required for transportable tablespace TOOLS:\r\n  \/u01\/app\/oracle\/oradata\/CDB19C\/PDB01\/tools01.dbf\r\nJob \"SYS\".\"SYS_EXPORT_TRANSPORTABLE_01\" successfully completed at Mon Jul 12 14:33:16 2021 elapsed 0 00:00:25<\/pre>\n<p>It worked! What if I my target version was 11.2.0.4?<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ expdp \\\"sys\/Rodrigo.123@localhost:1521\/pdb01 as sysdba\\\" transport_tablespaces=tools version=11.2.0.4\r\n\r\nExport: Release 19.0.0.0.0 - Production on Mon Jul 12 14:33:31 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nORA-39001: invalid argument value\r\nORA-39250: Using version to downgrade a transportable job is not supported\r\n<\/pre>\n<p>It returned:<\/p>\n<p><strong>ORA-39001: invalid argument value<\/strong><br \/>\n<strong>ORA-39250: Using version to downgrade a transportable job is not supported<\/strong><\/p>\n<p>Even though Oracle not officially support, you are not blocked from a 19c to 12.1.0.2, which is weird. It sounds like a <em>&#8220;we won&#8217;t block you, but try at your own risk<\/em>&#8220;.<\/p>\n<p>So, what happens when I import that dump into a 12c database:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@odbfcl-12-1-0-2 ~]$ impdp \\\"\/ as sysdba\\\" directory=DATA_PUMP_DIR dumpfile=expdat.dmp transport_datafiles=\/u01\/app\/oradata\/tools01.dbf\r\n\r\nImport: Release 12.1.0.2.0 - Production on Mon Jul 12 16:11:37 2021\r\n\r\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\nMaster table \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\" successfully loaded\/unloaded\r\nSource time zone version is 32 and target time zone version is 18.\r\nStarting \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\":  \"\/******** AS SYSDBA\" directory=DATA_PUMP_DIR dumpfile=expdat.dmp transport_datafiles=\/u01\/app\/oradata\/tools01.dbf\r\nProcessing object type TRANSPORTABLE_EXPORT\/PLUGTS_BLK\r\nORA-39123: Data Pump transportable tablespace job aborted\r\nORA-06550: line 2, column 2:\r\nPLS-00306: wrong number or types of arguments in call to 'BEGINIMPTABLESPACE'\r\nORA-06550: line 2, column 2:\r\nPL\/SQL: Statement ignored\r\n\r\nJob \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\" stopped due to fatal error at Mon Jul 12 16:11:38 2021 elapsed 0 00:00:01<\/pre>\n<p>It will fail with a <strong><span style=\"color: #993300;\">&#8220;PLS-00306: wrong number or types of arguments in call to &#8216;BEGINIMPTABLESPACE'&#8221;, <\/span><\/strong>which is not a bug, just a documented incompatibiliity.<\/p>\n<h4>2. Trying without version parameter in impdp<\/h4>\n<p>I will skip the expdp step, but once I try the impdp, I get the exact same error as before on <strong>12c<\/strong>. For <strong>11g<\/strong>, I get:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@odbfcl-11-2-0-4 ~]$ impdp \\\"\/ as sysdba\\\" directory=DATA_PUMP_DIR dumpfile=expdat.dmp transport_datafiles=\/u01\/app\/oradata\/tools01.dbf\r\n\r\nImport: Release 11.2.0.4.0 - Production on Mon Jul 12 16:42:50 2021\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORA-39001: invalid argument value\r\nORA-39000: bad dump file specification\r\nORA-39142: incompatible version number 4.1 in dump file \"\/u01\/app\/oracle\/admin\/orcl\/dpdump\/expdat.dmp\"<\/pre>\n<p>It failed with <span style=\"color: #800000;\"><strong>&#8220;ORA-39142: incompatible version number 4.1 in dump file&#8221;<\/strong><\/span>.<\/p>\n<p>If we check MOS Note <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=553337.1\" target=\"_blank\" rel=\"noopener\">Export\/Import DataPump Parameter VERSION &#8211; Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1)<\/a>, we have:<\/p>\n<p id=\"twJLBaJ\"><img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"228\" class=\"alignnone size-full wp-image-14562 \" src=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png\" alt=\"\" srcset=\"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png 833w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559-300x82.png 300w, https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559-768x210.png 768w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><\/p>\n<p>This explains why dump file has version <strong>4.1<\/strong> and why 11g can&#8217;t read it.<\/p>\n<h4>3. And what if I use the 19c impdp connect directly to the target databases?<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@odbfcl-19-0-0-0 ~]$ impdp \\\"sys\/Rodrigo.123@odbfcl-11-2-0-4:1521\/orcl as sysdba\\\" transportable=always dumpfile=expdat.dmp\r\n\r\nImport: Release 19.0.0.0.0 - Production on Mon Jul 12 16:51:11 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\nUDI-00018: Data Pump client is incompatible with database version 11.2.0.4.0\r\n\r\n[oracle@odbfcl-19-0-0-0 ~]$ impdp \\\"sys\/Rodrigo.123@odbfcl-12-1-0-2:1521\/orcl as sysdba\\\" transportable=always dumpfile=expdat.dmp\r\n\r\nImport: Release 19.0.0.0.0 - Production on Mon Jul 12 16:53:11 2021\r\nVersion 19.11.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\r\nUDI-00018: Data Pump client is incompatible with database version 12.1.0.2.0<\/pre>\n<p>They fail with <span style=\"color: #800000;\"><strong>&#8220;UDI-00018: Data Pump client is incompatible with database version X&#8221;<\/strong><\/span>.<\/p>\n<h4>4. Finally, and if I run the impdp from the 11g\/12c connecting on 19c using network_link?<\/h4>\n<p>First I will create the DB Link on the 11g\/12c pointing to the 19c PDB:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SQL&gt; CREATE DATABASE LINK test\r\nCONNECT TO test\r\nIDENTIFIED BY oracle\r\nUSING '\/\/odbfcl-19-0-0-0:1521\/PDB01';\r\n\r\nDatabase link created.<\/pre>\n<p>Now calling the impdp using this dblink:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@odbfcl-11-2-0-4 ~]$ impdp \\\"\/ as sysdba\\\" transport_tablespaces=tools network_link=test transport_datafiles=\/u02\/test\/tools01.dbf\r\n\r\nImport: Release 11.2.0.4.0 - Production on Mon Jul 12 16:56:26 2021\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORA-39001: invalid argument value\r\nORA-39169: Local version of 11.2.0.4.0 cannot work with remote version of 19.0.0.0.0.\r\n\r\n[oracle@odbfcl-12-1-0-2 ~]$ impdp \\\"\/ as sysdba\\\" transport_tablespaces=tools network_link=test transport_datafiles=\/u02\/test\/tools01.dbf\r\n\r\nImport: Release 12.1.0.2.0 - Production on Mon Jul 12 16:56:33 2021\r\n\r\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\nORA-39001: invalid argument value\r\nORA-39169: Local version of 12.1.0.2.0 cannot work with remote version of 19.0.0.0.0.<\/pre>\n<p>Got the <span style=\"color: #800000;\"><strong>&#8220;ORA-39169: Local version of X cannot work with remote version of 19.0.0.0.0.&#8221;<\/strong><\/span><\/p>\n<h4>Conclusion<\/h4>\n<p>It doesn&#8217;t work. =] So never try to use it as a fallback strategy.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-14559 jlk' href='javascript:void(0)' data-task='like' data-post_id='14559' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-14559 lc'>+4<\/span><\/a><\/div><\/div> <div class='status-14559 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Today my experiment will be trying to run a transportable tablespace to a lower release. The reason for this experiment is to evaluate a possible fast fallback plan in case I want to roll back a migration+upgrade (eg: 12c NON-CDB to 19c PDB). The first important thing to note is that the non-cdb to pdb &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-14559","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tranportable Tablespace to lower release? Is it possible? - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"This post will try some different scenarios to force a transportable tablespace to a lower release and show what happens.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Tranportable Tablespace to lower release? Is it possible?\",\"datePublished\":\"2021-07-12T17:30:59+00:00\",\"dateModified\":\"2021-07-12T17:43:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/\"},\"wordCount\":648,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/img_60ec783384559.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/\",\"name\":\"Tranportable Tablespace to lower release? Is it possible? - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/img_60ec783384559.png\",\"datePublished\":\"2021-07-12T17:30:59+00:00\",\"dateModified\":\"2021-07-12T17:43:21+00:00\",\"description\":\"This post will try some different scenarios to force a transportable tablespace to a lower release and show what happens.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/img_60ec783384559.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/img_60ec783384559.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2021\\\/07\\\/tranportable-tablespace-to-lower-release-is-it-possible\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tranportable Tablespace to lower release? Is it possible?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tranportable Tablespace to lower release? Is it possible? - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"This post will try some different scenarios to force a transportable tablespace to a lower release and show what happens.","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:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Tranportable Tablespace to lower release? Is it possible?","datePublished":"2021-07-12T17:30:59+00:00","dateModified":"2021-07-12T17:43:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/"},"wordCount":648,"commentCount":1,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/","url":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/","name":"Tranportable Tablespace to lower release? Is it possible? - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png","datePublished":"2021-07-12T17:30:59+00:00","dateModified":"2021-07-12T17:43:21+00:00","description":"This post will try some different scenarios to force a transportable tablespace to a lower release and show what happens.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2021\/07\/img_60ec783384559.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2021\/07\/tranportable-tablespace-to-lower-release-is-it-possible\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Tranportable Tablespace to lower release? Is it possible?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=14559"}],"version-history":[{"count":5,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14559\/revisions"}],"predecessor-version":[{"id":14570,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14559\/revisions\/14570"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=14559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=14559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=14559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}