Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> deleted files

deleted files

From: Yossie Mousalli <mousalli_at_applicom.co.il>
Date: Thu, 22 Oct 1998 17:58:45 +0200
Message-ID: <70nko2$9pr$1@news.netvision.net.il>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US