Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Help - accidentally deleted tablespace file
I am running Oracle 8.0.5 on Solaris.
I have a database with a number of tablespaces. In
one tablespace which has just two indexes in it,
I dropped the indexes, forgot to drop the tablespace,
then did a (Unix) rm to remove the
file that the tablespace was created with.
Now, when I try to do a dbstart, I get errors
ORA-01157: cannot identify data file 23 - data not found
ORA-01110: data file 23: (path to the file I deleted)
and I cannot get into sqlplus -
ORA-01033: ORACLE intialization or shutdown in progress
I can't restore the file from backup because I just created the tablespace today, and the backup job runs tonight. How do I undo my mess?
![]() |
![]() |