Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Relocating undo tablespace

Re: Relocating undo tablespace

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 09 Mar 2006 03:08:42 GMT
Message-Id: <pan.2006.03.09.03.08.41.938663@sbcglobal.net>


On Wed, 08 Mar 2006 05:35:34 -0800, EdStevens wrote:

> Mmm ... don't think so. My understanding is ALTER DATABASE RENAME ...
> is simply making the necessary change in the control file -- while the
> file is offline to the DB.. Doesn't matter if, at the OS level -- and
> wile the file is offline to the DB --- you 'move' the file or 'copy'
> the file.

Had some problems with that in 8i. I haven't done that in a while. Still, I'd rather copy.

-- 
http://www.mgogala.com
Received on Wed Mar 08 2006 - 21:08:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US