{"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\/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;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":2695,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[30,17,209],"class_list":["post-3056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-data-file","tag-oracle-11g","tag-oracle-12c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c: Moving a datafile is now possible online - dbi services | 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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"keywords\":[\"Data file\",\"Oracle 11g\",\"Oracle 12c\"],\"articleSection\":[\"Database\"],\"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 services | 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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"datePublished\":\"2013-07-15T22:24:00+00:00\",\"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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"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 services | 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 services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/bf7c7eb0bec165183207237c9d0ee1d5"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","keywords":["Data file","Oracle 11g","Oracle 12c"],"articleSection":["Database"],"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 services | 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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","datePublished":"2013-07-15T22:24:00+00:00","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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}