Subject: Re: Moving Datafiles
Newsgroups: comp.databases.oracle.server
References: <01bc9a4a$b0499140$990548a6@37055.NAC.PW.COM> <01bc9b28$b6868e80$741337a6@hercules> <33F1359D.96255D2C@cyberway.com.sg>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
Distribution:
John Li (johnli@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: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page