RE: What is the point to use "alter database rename file" command

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: jherrick_at_host.ott.igs.net

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: ListGuru_at_fatcity.com (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).