ORA-01187: cannot read from file 209 because it failed verification tests
ORA-01110: data file 209: ‘/oradata/temp01.dbf’
SQL> SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;
ERROR at line 1:
ORA-01187: cannot read from file 209 because it failed verification tests
ORA-01110: data file 209: ‘/oradata/temp01.dbf’
Resolved:
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘/oradata/temp02.dbf’ size50M;
SQL> ALTER TABLESPACE TEMP DROP TEMPFILE ‘/oradata/temp01.dbf’ ;