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: Data files lost

Re: Data files lost

From: <Rodion.Mironov_at_gmail.com>
Date: 14 Feb 2007 02:19:32 -0800
Message-ID: <1171448372.333795.59500@j27g2000cwj.googlegroups.com>


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

Original text of this message

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