Oracle 12c - Move datafile / tempfile

Oracle 12c with another great feature, moving datafile / tempfile.

Unfortunately TEMPFILES can't be moved, but can be dropped and recreated OR recreated (with another file name) and dropped.

WHILE THE DB is ON-LINE,

1) alter database move datafile <source destination - full path within single quotes> to <target destination - full path within single quotes> ;

IT does everything on the fly, great feature and handy for all DBA's.

for more info http://docs.oracle.com/database/121/ADMIN/dfiles.htm#ADMIN13837