Oracle Error Message
ORA-01516: nonexistent log file, data file, or temporary file “string”
Reason for the Error
An attempt was made to use ALTER DATABASE to rename a log file, data file, or temporary file; or to change attributes of a data file or temporary file (for example, resize, autoextend, online or offline); or to re-create or move a data file. The attempt failed because the specified file is not known to the database’s control file or is not of a type supported by the request.
Solution
Specify the name or number of an existing file of the correct type, as appropriate. Check the relevant V$ table for a list of possible files.
