Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data files lost
startup mount
alter database datafile ... offline drop
...
alter database open
On 14 ΖΕΧ, 11:57, "jeanor72" <gianluca.gr..._at_gmail.com> wrote:
> Hi all.
>
> On a test machine I've lost some data files, irremediabely I'm afraid.
> Well, I don't need their data, I was going to drop all tables and
> synchronize the server with an import from another instance. But
> without data files I'm not able access the server anymore. Is there a
> way to fix this accident or I've lost everything and have to reinstall
> the server from scratch?
>
> Thank you very much for your answers.
Received on Wed Feb 14 2007 - 04:19:32 CST
![]() |
![]() |