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
Leave a Reply