Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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"


Tim... said...


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!

Add your comments here.
(max 400 chars - plain text)