{"id":3056,"date":"2013-07-16T00:24:00","date_gmt":"2013-07-15T22:24:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/"},"modified":"2013-07-16T00:24:00","modified_gmt":"2013-07-15T22:24:00","slug":"oracle-database-12c-moving-a-datafile-is-now-possible-online","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/","title":{"rendered":"Oracle Database 12c: Moving a datafile is now possible online"},"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_Oracle_Database_12c.jpg\" alt=\"\" \/><\/p>\n<p>Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!<\/p>\n<p>Up to Oracle 11.2.0.3, you had three ways to relocate a datafile:<\/p>\n<ul>\n<li>Put the tablespace offline<\/li>\n<li>Put the datafile offline<\/li>\n<li>Shutdown and mount the database<\/li>\n<\/ul>\n<h3>Oracle 11g: Tablespace offline<\/h3>\n<p>Renaming a datafile by switching offline its tablespace requires four steps:<\/p>\n<p>1) Switching the tablespace offline<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER TABLESPACE DEMO OFFLINE NORMAL;<\/pre>\n<p>2) Moving the datafile with an Operating System command<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">$ mv '\/u01\/oradata\/DBTEST\/demo1.dbf' '\/u01\/oradata\/DBTEST\/demo01.dbf'<\/pre>\n<p>3) Changing the pointer to the data file<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE RENAME FILE '\/u01\/oradata\/DBTEST\/demo1.dbf'\nTO '\/u01\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>4) Switching the tablespace online<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER TABLESPACE DEMO ONLINE;<\/pre>\n<p>There are two important drawbacks:<\/p>\n<ul>\n<li>The database is partially unavailable during the operation: All data registered on the tablespace that is offline is unavailable.<\/li>\n<li>The default tablespace and the default temp tablespace cannot be switched offline.<\/li>\n<\/ul>\n<h3>Oracle 11g: Datafile offline<\/h3>\n<p>Renaming a datafile this way requires one step more (5):<\/p>\n<p>1) Switching the datafile offline<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE DATAFILE '\/u01\/oradata\/DBTEST\/demo1.dbf' OFFLINE;<\/pre>\n<p>2) Moving the datafile with an Operating System command<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">$ mv '\/u01\/oradata\/DBTEST\/demo1.dbf' '\/u01\/oradata\/DBTEST\/demo01.dbf'<\/pre>\n<p>3) Changing the pointer to the data file<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE RENAME FILE '\/u01\/oradata\/DBTEST\/demo1.dbf'\nTO '\/u01\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>4) Recovering the datafile before switching it online<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE RECOVER DATAFILE '\/u01\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>5) Switching the datafile online<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE DATAFILE '\/u01\/oradata\/DBTEST\/demo01.dbf' ONLINE;<\/pre>\n<p>There are two important drawbacks:<\/p>\n<ul>\n<li>The database is partially unavailable during the operation: All data registered on the datafile that is offline is unavailable.<\/li>\n<li>The datafile needs a media recovery since it is switched offline and SCN cannot be updated during offline time.<\/li>\n<\/ul>\n<h3>Oracle 11g: Shutdown and mount the database<\/h3>\n<p>The ultimate way to rename datafiles is to shutdown and mount the database. It allows to alter files that cannot be altered when the database is running &#8211; such as temporary tablespace, redo log files, etc. It requires five steps:<\/p>\n<p>1) Shutting down the database<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SHUTDOWN IMMEDIATE;<\/pre>\n<p>2) Mounting the database<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; STARTUP MOUNT;<\/pre>\n<p>3) Moving the datafile with an Operating System command<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">$ mv '\/u01\/oradata\/DBTEST\/demo1.dbf' '\/u01\/oradata\/DBTEST\/demo01.dbf'<\/pre>\n<p>4) Changing the pointer to the data file<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE RENAME FILE '\/u01\/oradata\/DBTEST\/demo1.dbf'\nTO '\/u01\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>5) Starting the database<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE OPEN;<\/pre>\n<p>The main drawback is simple to identify: The whole database is unavailable during the operation.<br \/>\nIn any case, up to Oracle 11g, a maintenance window was required in order to play with datafiles.<\/p>\n<h3>Oracle 12c: Alter Database Move Datafile<\/h3>\n<p>Starting with Oracle 12.1, you can now use the command ALTER DATABASE MOVE DATAFILE in order to rename, relocate, or copy a datafile when the datafiles or the database are online. One step only is required for any of these actions and the database remains entirely available in read and write for users, without any data loss.<\/p>\n<p>You should however be aware of some rules:<\/p>\n<ul>\n<li>By default, Oracle automatically deletes old data file after moving them and prevents the user from overwriting an existing file.<\/li>\n<li>When you move a data file, Oracle first makes a copy of the datafile. Then, when the file is successfully copied, pointers to the datafile are updated and the old file is removed from the file system. This is why the operation requires twice the size of the files to be copied as free space.<\/li>\n<\/ul>\n<p>Let&#8217;s have a look at some examples for the renaming or relocating of a datafile:<\/p>\n<p>1) Renaming a datafile<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE MOVE DATAFILE '\/u01\/oradata\/DBTEST\/demo1.dbf' TO '\/u01\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>2) Relocating a datafile<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE MOVE DATAFILE '\/u01\/oradata\/DBTEST\/demo01.dbf' TO '\/u02\/oradata\/DBTEST\/demo01.dbf';<\/pre>\n<p>The available options are:<\/p>\n<ul>\n<li>KEEP: to keep the old datafile, used to make a copy of the file. Note that the pointer will be updated to the new file,the\u00a0 old file only remains as unused on the filesystem. Note that on Windows, independently of the fact that the KEEP option is used or not, the old data file is not automatically deleted by Oracle. The user has to delete it manually after the copy is successfully performed.<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE MOVE DATAFILE '\/u01\/oradata\/DBTEST\/demo01.dbf' TO '\/u02\/oradata\/DBTEST\/demo01.dbf' <span style=\"color: #ff0000;\">KEEP<\/span>;<\/pre>\n<ul>\n<li>\u00a0REUSE: to overwrite an existing file.<\/li>\n<\/ul>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE MOVE DATAFILE '\/u01\/oradata\/DBTEST\/demo01.dbf' TO '\/u02\/oradata\/DBTEST\/demo01.dbf' <span style=\"color: #ff0000;\">REUSE<\/span>;<\/pre>\n<p>Moving a datafile online works in both ARCHIVE and NO ARCHIVE modes. You have no option to enable in order to use this feature, which is great. It does not work with an OFFLINE datafile.<br \/>\nOn the backup &amp; recovery side, a flashback database does not revert the operation. A datafile is definitively moved. But after moving a datafile, like for any other operation on the database structure, you will have to perform a new full backup of the database. Otherwise, you will have to move the datafile(s) back before being able to restore your database&#8230;<br \/>\nFinally, some files like temporary files, redo log files, and control files cannot be moved using this command, which is very helpful but can still be improved&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online! Up to Oracle 11.2.0.3, you had three ways to relocate a datafile: Put [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":2695,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[30,17,209],"type_dbi":[],"class_list":["post-3056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-data-file","tag-oracle-11g","tag-oracle-12c"],"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: Moving a datafile is now possible online - dbi Blog<\/title>\n<meta name=\"description\" content=\"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!\" \/>\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-database-12c-moving-a-datafile-is-now-possible-online\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c: Moving a datafile is now possible online\" \/>\n<meta property=\"og:description\" content=\"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-15T22:24: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_Oracle_Database_12c.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=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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-database-12c-moving-a-datafile-is-now-possible-online\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Database 12c: Moving a datafile is now possible online\",\"datePublished\":\"2013-07-15T22:24:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\"},\"wordCount\":716,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"keywords\":[\"Data file\",\"Oracle 11g\",\"Oracle 12c\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\",\"name\":\"Oracle Database 12c: Moving a datafile is now possible online - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"datePublished\":\"2013-07-15T22:24:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"width\":406,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c: Moving a datafile is now possible online\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c: Moving a datafile is now possible online - dbi Blog","description":"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!","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-database-12c-moving-a-datafile-is-now-possible-online\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c: Moving a datafile is now possible online","og_description":"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/","og_site_name":"dbi Blog","article_published_time":"2013-07-15T22:24: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_Oracle_Database_12c.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Database 12c: Moving a datafile is now possible online","datePublished":"2013-07-15T22:24:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/"},"wordCount":716,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","keywords":["Data file","Oracle 11g","Oracle 12c"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/","name":"Oracle Database 12c: Moving a datafile is now possible online - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","datePublished":"2013-07-15T22:24:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","width":406,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-moving-a-datafile-is-now-possible-online\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c: Moving a datafile is now possible online"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3056","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3056"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3056\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2695"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3056"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}