Re: ORA-01157; Missing Datafile
From: Carol KIlner <kilnerc_at_basf-corp.com>
Date: 17 Feb 1995 20:10:14 GMT
Message-ID: <3i2vr6$1cq_at_basfigw.basf-corp.com>
Date: 17 Feb 1995 20:10:14 GMT
Message-ID: <3i2vr6$1cq_at_basfigw.basf-corp.com>
I deleted a datafile on an Oracle 7 database. To get it back try: version 7
startup mount;
alter database create datafile 'old' as 'new';
(Note just make old and new the same keeping the quotes)
alter database recover;
alter database open;
Hope this helps.
Thanks,
C. Kilner
Received on Fri Feb 17 1995 - 21:10:14 CET