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 -> Re: Manuell deleted Datafile

Re: Manuell deleted Datafile

From: Mario Koch <m.koch_at_md-netz.de>
Date: Sun, 4 Jul 2004 15:29:46 +0200
Message-ID: <cc90oa$ude$04$1@news.t-online.com>


Thanks for your wonderfull tips, but it's a test-db and not the working-db and so i havn't backups.
Can you tell where i can i found the recylce bin. I'm not the linux-freak ...
Mario Koch

"Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1088902365.962056_at_yasure...
> Mario Koch wrote:
>
> > I have manually deleted a datafile (.dbf) from the oracle database. Now
the
> > database never start.
> > What can I do to correct these problem ? This was a tablespace for
testing
> > and it can complete delete from database.
> >
> > and others:
> > Whow can i delete a datafile from a tablespace with sql-comand.
> >
> > greetings mario
>
> If you have a backup ... restore it.
>
> If not you are S.O.L. unless by some miracle you are on Windows and
> a copy is sitting in the recycle bin.
>
> There is a reason databases are backed up. ;-)
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Sun Jul 04 2004 - 08:29:46 CDT

Original text of this message

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