8i | 9i | 10g | 11g | 12c | 13c | 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!


Prabhakar Kumar said...

Awesome article, makes everything crystal clear about Oracle Online Move of datafile.

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!