2023-12-01 13:52阅读: 29评论: 0推荐: 0

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

 

posted @   雪竹子  阅读(29)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
历史上的今天:
2022-12-01 单文件版软件怎么制作?使用VMWare ThinApp制作单文件软件教程
2020-12-01 在sed中引入shell变量的四种方法
点击右上角即可分享
微信分享提示
💬
评论
📌
收藏
💗
关注
👍
推荐
🚀
回顶
收起