Re: Moving Datafiles

John Li (johnli_at_cyberway.com.sg) 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:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->