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 -> How to use "alter database create datafile ... as"?

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

From: Terry Mu <terry_mu_at_yahoo.com>
Date: Fri, 01 Nov 2002 05:15:22 GMT
Message-ID: <K5ow9.138553$Q3S.3923@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 Thu Oct 31 2002 - 23:15:22 CST

Original text of this message

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