ORA-01187,ORA-01110

Oracle Database 11.2.0.4

Symptoms

SQL> select file_name from dba_temp_files;
select file_name from dba_temp_files
*
ERROR at line 1:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: 'E:\ORACLE\ORADATA\IC\TEMP01.DBF'

Solution

  1. Check the tablespace name.
select * from v$tablespace;
  1. Add the tempfile with new name into temp tablespace.
alter tablespace TEMP add tempfile 'E:\ORACLE\ORADATA\IC\TEMP_01.DBF' SIZE 100M AUTOEXTEND ON NEXT 100M;
  1. Drop the tempfile which causing problem.
alter database tempfile 'E:\ORACLE\ORADATA\IC\TEMP01.DBF' drop;
  1. Delete the tempfile from file system.