|Online Move Datafile in Oracle Database 12c Release 1 (12.1) - Rename and relocate datafiles with no downtime in Oracle Database 12c Release 1 (12.1).|
Adam said...RE: Online move doesn't work for TEMP files
ORA-01516: nonexistent log file, data file, or temporary file "/u01/app/oracle/oradata/cdb1/temp01.dbf"
Ok, so it doesn't work, that's fine. But assuming the temp file you specified does actually exist, for me it's another strange/misleading Oracle error message.. because it says
"nonexistent.. temporary file"
Agreed. It would be better if it told you moving temp files was unsupported and unnecessary. :)
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!