问题:
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