Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Manuell deleted Datafile
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