ORA-01516: nonexistent log file, data file, or temporary file "+DATA"

ORA-01516: nonexistent log file, data file, or temporary file "+DATA"


SQL> alter database tempfile 1 drop including datafiles;
alter database tempfile 1 drop including datafiles
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "+DATA"


Solution
--------------


alter TABLESPACE APPS_TEMP drop tempfile 1;

or


alter TABLESPACE APPS_TEMP1 drop tempfile '/erp_data/oradata/APPS_TEMP1_01.dbf';


add the temporary file if it required


alter TABLESPACE APPS_TEMP add tempfile '/erp_temp/oradata/APPS_TEMP1_02.dbf' SIZE 25500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;