ORA-01157: cannot identify/lock data file

 

Wed Apr 11 22:13:53 2012
Errors in file d:\oracle\product\10.2.0\admin\sdh\bdump\sdh_dbw0_1552.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'C:\ORACLEDATA\EXAMPLE_DATA.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) 系统找不到指定的路径。

 

--测试环境可以直接这么搞，做完之后数据就没拉，正式库不要这么玩

alter database datafile 6 offline drop;

alter database open;

drop tablespace example including contents;

转载于:https://www.cnblogs.com/rambler/archive/2012/04/12/2443386.html