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> […]
Read more →