Nope, goes back to at least 7.1 =8-) can't speak for 6 and pre 6 as I'm not that old :) (I am but I was too busy with 4 other types of db's!)
The point is that you're only affecting 1 tablespace, the rest of the db stays available. Similarly, the window of 'unavailability' is smaller of you're only moving a couple of files versus all files (even with the speed of an 'mv' command) I guess the command would be pointless if you're the only user of the database and hence the only user being disrupted. =8-0 Jeff Herrick On Tue, 9 Jul 2002, Mercadante, Thomas F wrote: > Jalil, > > You have to remember that some of these commands have been around for > awhile. The "Alter database" command was the *only* way we could move data > files in earlier versions of Oracle. Rebuilding new control files was only > introduced just recently (in 8.0 I believe). > > I still would not rebuild a control file just to move a data file to a new > location. Some of us old codgers are superstitious about these > "new-fangled-ways"! > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > -----Original Message----- > Sent: Tuesday, July 09, 2002 8:48 AM > To: Multiple recipients of list ORACLE-L > > > > Hi list, > What is the point to use "alter database rename file" > command to move datafile? as we will need to update > controle file anyway. So why not do the following directly > to move datafile: > - alter database backup contrlfile to trace and modify > the location of datafile. > - startup nomount and run the script inorder to update > the controlfile. It works fine... > > So what is the point of "alter database rename file" command? > > Thanks in advance. > Regards, > -Jalil > > > > > _____ > > Do You Yahoo!? > New! SBC > <http://pa.yahoo.com/*http://rd.yahoo.com/sbcyahoo/consumer/evt=640/*http:// > sbc.yahoo.com> Yahoo! Dial - 1st Month Free & unlimited access > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
