Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!newsfeed1.cidera.com!Cidera!netnews.com!xfer02.netnews.com!newsfeed2.earthlink.net!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED!not-for-mail Message-ID: <3CAC86A9.82885B1A@BACKSIESearthlink.net> From: Sean M X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Editing the Control Files References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 25 Date: Thu, 04 Apr 2002 17:00:17 GMT NNTP-Posting-Host: 206.71.120.1 X-Complaints-To: abuse@earthlink.net X-Trace: newsread2.prod.itd.earthlink.net 1017939617 206.71.120.1 (Thu, 04 Apr 2002 09:00:17 PST) NNTP-Posting-Date: Thu, 04 Apr 2002 09:00:17 PST Organization: EarthLink Inc. -- http://www.EarthLink.net Xref: easynews comp.databases.oracle.server:142043 X-Received-Date: Thu, 04 Apr 2002 09:57:58 MST (news.easynews.com) Arash wrote: > > Hi! > what can I do if: > > - when I want to start my oracle server says: > ORA-01157: cannot identify/lock data file 1 - see DBWR trace file > ORA-01110: data file 1:'D:\ORATEST\SYSTEM01.DBF' > > - my problem is, that my *.DBF's are located in another directory. > > but I cant edit my CTL-files, to tell this to the server... > ...or can I? > > and if, how? Two choices: 1) rename the datafiles while the database is mounted, but not open, using 'alter database rename datafile to ' (check my syntax on that - going from memory). 2) Recreate your controlfile with the new filenames/locations (i.e. in a nomount stage, issue 'create controlfile blah blah blah'). The former is probably your best bet - less chance to screw something up. Regards, Sean