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
微信赞赏
支付宝赞赏