Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!xmission!isdnet!sn-xit-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Editing the Control Files Date: Thu, 04 Apr 2002 19:05:32 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <5o1paucu26r1ouabruob54ukcch0asi5n8@4ax.com> Reply-To: postbus@sybrandb.demon-verwijderdit.nl References: X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 38 Xref: easynews comp.databases.oracle.server:142045 X-Received-Date: Thu, 04 Apr 2002 10:02:13 MST (news.easynews.com) On 4 Apr 2002 08:39:38 -0800, arashamiri@hotmail.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? > >please help... >arash. go into svrmgrl connect / as sysdba startup mount alter database rename file '....' to '....'; -- please check out the exact syntax in your sql reference manual alter database backup controlfile to trace; alter database open; -- done exit Never even think of editing the controlfiles, and definitely not before reading any Oracle server administrators manual. Regards Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address