今天,在做exp练习时,输入以下句子:exp system/manager file=/disk/exp/orcl.dmp log=/disk/exp/orcl.log indexes=n full=y后,出现以下错误:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'
在网上找了解决办法,解决了。
解决方法:
解决办法:
1. 册除临时表
2. 再重建数据文件
[sql]
1.ys@DENVER> alter database tempfile '/u01/oradata/md/temp01.dbf' drop;
2.
3.Database altered. 4.
5.sys@DENVER> select file#, ts#, name, status from v$tempfile; 6.
7.no rows selected 8.
9.sys@DENVER> alter tablespace temp add tempfile '/u01/oradata/md/temp01.dbf' size 512m reuse; 10.
11.Tablespace altered.
12.
13.sys@DENVER> select file_name, status from dba_temp_files; 14.
15.FILE_NAME STATUS
16.---------------------------------------- ------- 17./u01/oradata/md/temp01.dbf ONLINE