ORA-01157: cannot identify/lock data file

Receive below message on a tempfile:

ORA-01157: cannot identify/lock data file 201 – see DBWR trace file

Sooo…add a tempfile and drop a tempfile:

SQL> alter tablespace temp add tempfile ‘/mypath/temp01.dbf’ size 2000m;

SQL> alter database tempfile ‘/myoldpath/fileitscomplainingabout01.dbf’ drop;

Advertisements