Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to use "alter database create datafile ... as"?
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