{"id":3198,"date":"2013-08-20T08:00:00","date_gmt":"2013-08-20T06:00:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/"},"modified":"2013-08-20T08:00:00","modified_gmt":"2013-08-20T06:00:00","slug":"oracle-12c-pdbs-not-yet-full-transportable","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/","title":{"rendered":"Oracle Database 12c: PDBs not fully transportable yet"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\" alt=\"\" \/><\/p>\n<p>One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.<\/p>\n<h3>Multi-tenant database overview<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CDB_layout.png\" alt=\"CDB_layout\" width=\"457\" height=\"593\" \/><\/p>\n<p>It is not the scope of this post to explain the multi-tenant database concept, it will be presented on lots of other dedicated posts. Furthermore it has been largely introduced by Oracle on several conferences even before the 12c launch.<\/p>\n<p>Just to give a brief overview, multi-tenant databases (pluggable databases) allow to consolidate several databases (applications) under one single &#8220;container database&#8221; (CDB). This allows to isolate applications in separate databases (containers) having their own tablespaces, users, dictionary but sharing the same instance, the same redo log files and other shared components. We benefit from better isolation than schema consolidation, indeed pluggable databases can be easily moved, restored, aso &#8230; without affecting other pluggable databases. The current Oracle 12c release has however some limits and issues, see (<a href=\"http:\/\/dbi-services.com\/blog\/oracle-12c-pluggable-databases-not-that-isolated\/\">http:\/\/dbi-services.com\/blog\/oracle-12c-pluggable-databases-not-that-isolated\/<\/a>). Since the PDBs share the same memory and process structures the CPU and memory consumption will be reduced allowing to run several (pluggable) databases (PDBs) on the same server (compared to the classical database\/instance architecture).<\/p>\n<p>There are several ways to create a pluggable database :<\/p>\n<ul>\n<li>Copy from a seed (integrated template)<\/li>\n<li>Copy from an existing PDB (local or remote)<\/li>\n<li>By unplugging\/plugging a pluggable database from one Container Database to another<\/li>\n<\/ul>\n<p>The exhibit below resumes these possibilities :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PDB_creation_tree.png\" alt=\"PDB_creation_tree\" width=\"678\" height=\"387\" \/><\/p>\n<p>To be complete it is also important to mention that PDBs can also be duplicated with RMAN.<\/p>\n<h3>PDB creation through a DB link<\/h3>\n<p>This post will focus on the creation of a pluggable database (PDB) through a database link. The goal might be to &#8220;transport&#8221; a PDB from one Container Database (CDB) to another, eventually located on a different physical server.<\/p>\n<p>For this purpose, some conditions must be full filled :<\/p>\n<ul>\n<li>Remote (Source) DB must be opened in read-only mode<\/li>\n<li>Link must exist to the remote CDB<\/li>\n<li>Current user must have the \u201cCREATE PLUGGABLE DATABASE\u201d privilege on the destination CDB as the user used by the DB link<\/li>\n<li>Source and destination CDB must have:\n<ul>\n<li>The same endianness<\/li>\n<li>Compatible database options installed<\/li>\n<li>Compatible (national) character sets<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>As stated previously I was confronted with some issues while using this feature during the beta tests and Oracle opened and worked on several bugs. Let&#8217;s check if it works now \ud83d\ude42 ?<\/p>\n<p>First of all, create the source PDB (PDB1) on the source container (CDB121) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; CREATE PLUGGABLE DATABASE PDB1\n\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ADMIN USER pdb1_admin IDENTIFIED BY manager\n\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DEFAULT TABLESPACE APPLICATION_DATA\n\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DATAFILE '\/u01\/oradata\/PDB1\/application_data_01.dbf'\n\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SIZE 100M AUTOEXTEND ON NEXT 32M\n\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PATH_PREFIX = '\/u01\/oradata\/PDB1'\n\u00a0 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FILE_NAME_CONVERT = ('\/u01\/oradata\/CDB121\/pdbseed',\n\u00a0 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 '\/u01\/oradata\/PDB1');\nPluggable database created.<\/pre>\n<p>&nbsp;<\/p>\n<p>We are currently connected to the CDB :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; show con_idCON_ID\n ------------------------------\n 1\n\u00a0\nSQL&gt; SELECT CON_ID,DBID,NAME,OPEN_MODE FROM V$containers;\nCON_ID\u00a0\u00a0\u00a0\u00a0 DBID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE\n ---------- ---------- ---------------------- ----------\n 1 3781127169\u00a0\u00a0\u00a0\u00a0 CDB$ROOT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ WRITE\n 2 4063553988\u00a0\u00a0\u00a0\u00a0 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\n 3 3328657606\u00a0\u00a0\u00a0\u00a0 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/pre>\n<p>&nbsp;<\/p>\n<p>We swich to the created PDB (PDB1) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter session set container = PDB1;\nSession altered.<\/pre>\n<p>&nbsp;<\/p>\n<p>We open it (in READ ONLY as stated by the documentation) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter pluggable database open read only;\nPluggable database altered.\n\u00a0\nSQL&gt; SELECT CON_ID,DBID,NAME,OPEN_MODE FROM V$containers;\n\u00a0\u00a0\u00a0 CON_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DBID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE\n ---------- ---------- --------------------- ----------\n 3 3328657606 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\n1 row selected.<\/pre>\n<p>&nbsp;<\/p>\n<p>On the destination container (NCDB121), create a database link to the source container (CDB121) :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; CREATE PUBLIC DATABASE LINK CDB121\n 2\u00a0 CONNECT TO SYSTEM IDENTIFIED BY manager\n 3\u00a0 USING 'CDB121.IT.DBI-SERVICES.COM'\n 4\u00a0 \/\nDatabase link created.<\/pre>\n<p>&nbsp;<\/p>\n<p>Now create the NPDB1 PDB in NCDB121 through the database link. Of course we have to change the path of the NPDB1 datafiles, they will be located under &#8220;\/u01\/oradata\/NPDB1&#8221; instead of &#8220;\/u01\/oradata\/PDB1&#8221;, this is supposed to be managed by the FILE_NAME_CONVERT parameter :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; CREATE PLUGGABLE DATABASE NPDB1\n 2 FROM PDB1@CDB121\n 3 FILE_NAME_CONVERT = ('PDB1','NPDB1')\n 4\/\nFROM PDB1@CDB121\n *\n ERROR at line 2:\n ORA-17628: Oracle error 19505 returned by remote Oracle server\n ORA-19505: failed to identify file \"\"<\/pre>\n<p>&nbsp;<\/p>\n<p>As you can see, unfortunately it still fails, Oracle is still investigating this issue. The same tests failed also with the following values for FILE_NAME_CONVERT : (&#8216;\/u01\/oradata\/PDB1&#8242;,&#8217;\/u01\/oradata\/NPDB1&#8217;). We are still in contact with Oracle on this topic and hope we will be able to quickly provide successful results about this feature.<\/p>\n<p>This feature has also been tested with the session parameter PDB_FILE_NAME_CONVERT without success.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":3199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[320,209,353],"type_dbi":[],"class_list":["post-3198","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-multitenant-database","tag-oracle-12c","tag-pluggable-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c: PDBs not fully transportable yet - dbi Blog<\/title>\n<meta name=\"description\" content=\"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.\" \/>\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.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c: PDBs not fully transportable yet\" \/>\n<meta property=\"og:description\" content=\"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-20T06:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"406\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yann Neuhaus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yann Neuhaus\" \/>\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:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\"},\"author\":{\"name\":\"Yann Neuhaus\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681\"},\"headline\":\"Oracle Database 12c: PDBs not fully transportable yet\",\"datePublished\":\"2013-08-20T06:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\"},\"wordCount\":654,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\",\"keywords\":[\"Multitenant database\",\"Oracle 12c\",\"Pluggable Database\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\",\"name\":\"Oracle Database 12c: PDBs not fully transportable yet - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\",\"datePublished\":\"2013-08-20T06:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681\"},\"description\":\"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg\",\"width\":406,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c: PDBs not fully transportable yet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681\",\"name\":\"Yann Neuhaus\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"caption\":\"Yann Neuhaus\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c: PDBs not fully transportable yet - dbi Blog","description":"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.","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.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c: PDBs not fully transportable yet","og_description":"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/","og_site_name":"dbi Blog","article_published_time":"2013-08-20T06:00:00+00:00","og_image":[{"width":406,"height":100,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg","type":"image\/jpeg"}],"author":"Yann Neuhaus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yann Neuhaus","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/"},"author":{"name":"Yann Neuhaus","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"headline":"Oracle Database 12c: PDBs not fully transportable yet","datePublished":"2013-08-20T06:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/"},"wordCount":654,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg","keywords":["Multitenant database","Oracle 12c","Pluggable Database"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/","name":"Oracle Database 12c: PDBs not fully transportable yet - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg","datePublished":"2013-08-20T06:00:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"description":"One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this topic is that I was confronted with some issues during my beta tests, so I would like to verify again if everything works now.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_b2ap3_thumbnail_Oracle_Database_12c_20130821-071054_1.jpg","width":406,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-pdbs-not-yet-full-transportable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c: PDBs not fully transportable yet"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681","name":"Yann Neuhaus","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","caption":"Yann Neuhaus"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3198"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3199"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3198"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}