Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01187: Cannot read from file string because it failed verification test

549698Dec 23 2008 — edited Aug 17 2012

Hi,

I'm running OWB etl on oracle 9.2.0.7. since huge etl loading was taking too much of temp tablespace space,which couse the filesystem to reach 100%,I killed the ETL session and drop the temp tablespace.I then recreated it with diffrent tempfile names..

Now when run the etl I faced error ORA-01187 cannot read from file 201 because it failed verification tests ORA-0110 : data file 201:/u08/oradata/SID/temp_02.dbf". But tempfile /u08/oradata/SID/temp_02.dbf does not exist now as I have created a new tempfile for the tablespace and have given a new name.

For solution I have apply command,"*ALTER SYSTEM CHECK DATAFILES*".How would I know if the prblm is resolve,as the tempfile is not there..

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2012

Added on Dec 23 2008

#general-database-discussions

4 comments

4,816 views