Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> deleted files
By mistake I create a new table under USERS and deleted it.
The problem is that when I try to startup my db I get an error that the file
doesn't exists. This file was new and empty.
Can I remove this configuration and startup my db?
The errors are:
SQLDBA> connect internal
Connected.
SQLDBA> startup
ORACLE instance started.
Database mounted.
ORA-01157: cannot identify data file 10 - file not found
ORA-01110: data file 10: '/project/oracle/dbs/newfilename'
Attempting to dismount database........Database dismounted.
Attempting to shutdown instance........ORACLE instance shut down.
Sincerely
Yossie
Received on Thu Oct 22 1998 - 10:58:45 CDT