Re: How to use "alter database create datafile ... as"?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 1 Nov 2002 16:50:28 +1000
Message-ID: <3qow9.67009$g9.188519@newsfeeds.bigpond.com>

Hi Terry,

Correct, although in the second example you don't need the AS clause.

Providing you have all the redo logs since the file was created, you can now successfully recover the data file.

Good Luck

Richard
"Terry Mu" <terry_mu_at_yahoo.com> wrote in message news:K5ow9.138553$Q3S.3923_at_news01.bloor.is.net.cable.rogers.com...
> Senario: file1 on disk1 is lost and not backed up.
>
> I understand that if disk1 is lost, I should do:
> alter database create datafile '/disk1/file1' as '/disk2/newfile1';
>
> but if disk1 is ok, can I use
> alter database create datafile '/disk1/file1' as '/disk1/filel1';
>
> thanks
>
>
Received on Fri Nov 01 2002 - 00:50:28 CST