ORA-01187和ORA-01110

问题：

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

ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'

解决办法：

1. 册除临时表

2. 再重建数据文件

1、alter database tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZTSYS\TEMP01.DBF' drop; 

select file#, ts#, name, status from v$tempfile t where t.NAME like '%TEMP01%'; 
no rows selected 
2、 alter tablespace temp add tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZTSYS\TEMP01.DBF' size 512m reuse;  

select file#, ts#, name, status from v$tempfile t where t.NAME like '%TEMP01%';  

     FILE#        TS#  NAME                                                                                                         STATUS
     1                   3     D:\ORACLE\PRODUCT\10.2.0\ORADATA\ZTSYS\TEMP01.DBF   ONLINE