ORA-01187 and ORA-01110 errors Regarding Temp Files

 

Assume that the default temp table space of the system is TMP.

ERROR:

ORA-01187: can not read from file because it failed verification tests
ORA-01110: data file n: ‘/oradata/orcl/temp01.dbf’

SOLUTION:

We create a new temp tablespace on the system.

 

We set the default temp tablespace of the system as newly created TEMP2.

 

We are dropping the old temp tablespace.

 

We are re-creating the old default temp tablespace. This and the next step is not necessary. but you can apply it for use with default settings.

 

The default temp is changed back to TMP tablespace.

 

The temporarily created temp2 tablespace is deleted.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *