Move datafiles online - Oracle 12c New feature

Do you remember the time when you had to move a datafile ... In Oracle 12c you can now move online datafiles with one simple statement: ALTER DATABASE MOVE DATAFILE

And even if there is transactions using these datafiles ... Session #1 Session #2 Where's what we can see in the alert.log ... You can even move SYSTEM, SYSAUX and UNDO datafiles with this statement ... so let's move all datafiles ONLINE ! IMPORTANT: Don't forget to backup after database structural changes. Hit the Oracle 12c documentation for more info ... Renaming and Relocating Online Data Files http://docs.oracle.com/cd/E16655_01/server.121/e17636/dfiles.htm#ADMIN13837 Restrictions When Moving the Location of Online Data Files http://docs.oracle.com/cd/E16655_01/server.121/e17640/standby.htm#SBYDB5159