Database Administration (MOSC)

MOSC Banner

ORA- 01187: cannot read from file || Ora- 011170 data file 201

edited Jul 23, 2020 5:21AM in Database Administration (MOSC) 15 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center