8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Online Move Datafile 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. :)



Holger said...

It might be worth noting that this is an EE feature. Trying to move a datafile in SE results in ORA-00439: Feature not enabled: online move datafile. But great article nevertheless!


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!