ORA- 01187: cannot read from file || Ora- 011170 data file 201
Hi Everyone,
I am having a problem creating the RCU for the OID. while verification we realized it the temp file from the database that is causing the issue.
Database : 12.1.0.2
Server : windows server 2008 R2
OID : 12.2.1.3.0
Select * from dba_temp_files;
Error at line 1:
ORA_01187: cannot read from file because it failed verification tests
ORA-01110 : data file 201: "<location of the dbf file>"
so i tried deleting the temp tablespace
SQL> drop tablespace temp01 including contents and datafiles;
Error at line 1:
ORA-00959: tablespace 'Temp01' does not exist
I am able to create a temp 02. dbf file and also able to drop.