Question: How do you move a datafile in Oracle?
Answer: In Oracle 12c and beyond it is easy to move
a datafile. Just use the following syntax and you can
move a "live" datafile:
alter database
move datafile
'/u01/app/oracle/oradata/system.dbf'
to
'/u02/app/oracle/oradata/my12c_db/system.dbf';