ORA-01110 ORA-27041
381879Mar 19 2004 — edited Mar 23 2004I accidently deleted some datafiles that were part of a tablespace. I don't care about the data because I had not yet used these datafiles. But when my database won't startup because it has the following error in the trace file.
I dont have a back up of these files.
How do I solve this problem.
Thanks
Venkat
ORA-01157: cannot identify/lock data file 54 - see DBWR trace file
ORA-01110: data file 54: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE2.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 55 - see DBWR trace file
ORA-01110: data file 55: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE3.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 56 - see DBWR trace file
ORA-01110: data file 56: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE4.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 57 - see DBWR trace file
ORA-01110: data file 57: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE5.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 58 - see DBWR trace file
ORA-01110: data file 58: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE6.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file