ORA-01187 cannot read from file 201 because it failed verification tests..temp01
Description:
We get this message in running the Upgrade Express 20-21 export (create_customer_data):
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
ORA-06512: at "SYS.DBMS_LOB", line 555
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3487
util o/14/1 also shows the error message for tablespace TEMP:
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
Resolution:
If you have a DBA, that person should handle the following dropping/recreating of the TEMP tablespace....
We used the instructions found at http://dbaspot.com/database-discussi...-tempfile.html:
> s+ aleph_admin
aleph_admin@ALEPH20> create temporary tablespace temp1
2 tempfile '/oradata/10g/oracle/temp101.dbf' size 64M;
tempfile '/exlibris/oradata/aleph20/aleph20_temp101.dbf' size 64M;
Tablespace created.
aleph_admin@ALEPH20> alter database default temporary tablespace temp1;
Database altered.
aleph_admin@ALEPH20> quit
> sudo su - root [logon as root to drop the temp01.dbf datafile]
root...> cd /exlibris/oradata/aleph20/
root...> rm temp01.dbf
root...> exit
> s+ aleph_admin
aleph_admin@ALEPH20> drop tablespace temp ;
Tablespace dropped.
aleph_admin@ALEPH20> create temporary tablespace temp
2 tempfile '/oradata/10g/oracle/temp01.dbf'
3 size 128M autoextend on next 64M maxsize 257M
4 extent management local;
tempfile '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
size 64M;
Tablespace created.
aleph_admin@ALEPH20> alter database default temporary tablespace temp;
Database altered.
SQL> drop tablespace temp1 including contents and datafiles;
Tablespace dropped.
aleph_admin@ALEPH20> create temporary tablespace temp
tempfile '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
size 128M autoextend on next 64M maxsize 257M
extent management local;
After which, util o/14/1 showed a proper listing for tablespace TEMP:
Temporary Tablespace Space Usage
TABLESPACE_NAME SIZE M
------------------------------ ----------
TEMP 115.063206
Sort Segments Usage (in Temporary Tablespace)
TABLESPACE_NAME Total M Used M Free M
------------------------------- ---------- ---------- ----------
TEMP 12 5 7
微信赞赏

支付宝赞赏

【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
2022-12-01 单文件版软件怎么制作?使用VMWare ThinApp制作单文件软件教程
2020-12-01 在sed中引入shell变量的四种方法