Oracle 12c: Move datafile feature
Until the release 11g move a datafile was an operation very problematic; We had to put the tablespace offline, copy the datafile to the new destination and rename it : SQL> alter database rename datafile “A” to “B”; From Oracle release Oracle 12c, you can move a datafile from a mount point to another without having to put the tablespace offline . All this is done while the database is active. So with the command: alter database move datafile ‘/u01/app/oracle/oradata/FILE.dbf’ to ‘/u02/app/oracle/oradata/ORADB12/FILE.dbf’; It is also possible to move a datafile from specific number that Oracle has assigned...