There is one case which took me even more than 1 hour to find correct way to fix it.The symptom is quite simple:- We found there is one datafile in v$datafile has name of 'MISSING9999'.- DBA_DATA_FILES shows following:FILE_NAMEFILE_IDTABLESPACE_NAMEB...