Re: deleted files

From: <satar_at_my-dejanews.com>
Date: Thu, 22 Oct 1998 21:16:54 GMT
Message-ID: <70o7c6$oc4$1@nnrp1.dejanews.com>

I am confused...You created a Table or Tablespace? Anyway, the datafile that is missing must be recovered or you must remove the tablespace that the datafile belongs to. There is no easy way around it.

Satar

In article <70nko2$9pr$1_at_news.netvision.net.il>, "Yossie Mousalli" <mousalli_at_applicom.co.il> wrote:
> 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
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 16:16:54 CDT