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. :)
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!