Subject: Re: Moving Datafiles
References: <01bc9a4a$b0499140$990548a6@37055.NAC.PW.COM> <01bc9b28$b6868e80$741337a6@hercules> <>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider

John Li ( wrote:
: Is it possible to recreate the control file with the new locations of
: the data files?
: ie. after connecting as internal, run "alter database backup controlfile
: to trace". This will create a .trc file in the log directory. Can I then
: edit this file after moving the data file/s and then use this file to
: recreate the control file?
: I have only tried this method to increate the value of maxdatafiles but
: not to relocate datafiles and I've always wonder whether it can be done
: that way.
: John

Yes, this is one of the best features of the "create controlfile" script.
Simply modify the locations of the datafiles and run the script. I have
done this many times.

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 100+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->                                    <->
<->                                                               <->
<->             email:                    <->

Back to Ari Kaplan's Home Page k to Ari Kaplan's Home Page