deleted files
From: Yossie Mousalli <mousalli_at_applicom.co.il>
Date: Thu, 22 Oct 1998 17:58:11 +0200
Message-ID: <70nkmu$9os$1_at_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 - 17:58:11 CEST
Date: Thu, 22 Oct 1998 17:58:11 +0200
Message-ID: <70nkmu$9os$1_at_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 - 17:58:11 CEST