ORA-01187: cannot read from file because it failed verification tests + ORA-01110 on tempfiles

ORA-01187: cannot read from file because it failed verification tests + ORA-01110 on tempfiles

SQL> select file_name from dba_temp_files;

ERROR:

ORA-01187: cannot read from file because it failed verification tests

ORA-01110: data file 205: '/DATA/database/ifsprod/temp_01.dbf'

Drop the tempfile from the database:

SQL> alter database tempfile '/DATA/database/ifsprod/temp_01.dbf' drop;

Following query will create temp tablespace named: ‘TEMP_NEW’ with 500 MB size along with auto-extend and maxsize unlimited.

SQL> CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '/DATA/database/ifsprod/temp_01.dbf' SIZE 500m autoextend on next 10m maxsize unlimited;

Following query will help you to alter database for default temporary tablespace. ( i.e. Newly created temp tablespce: ‘TEMP_NEW’ )

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_NEW;