Re: Relocating undo tablespace

From: JEDIDIAH <jedi_at_nomad.mishnet>
Date: Fri, 10 Mar 2006 10:01:42 -0600
Message-ID: <6gk8e3-b5d.ln1@nomad.mishnet>

On 2006-03-08, EdStevens <quetico_man_at_yahoo.com> wrote:
> Platform: Oracle 9.2.0.6 on Solaris 5.9
>
> Hit a snag today on a box that holds two instances - one for dev, one
> for QA for the same app. Started getting alerts that two of the file
> systems had filled up. The SA had recently added a LUN to another disk
> group, so we created a couple of 'overflow' file systems there. One of
> the full FS's had normal data files, and I was able to relocate some of
> them to these new file systems on the other disk group. The other
> tablespace has only one of the control file mirrors, and the undo
> tablespace. I'm a little antsy about relocating that one. The
> procedure I used for the normal data files was:
> 1) offline the TS,
> 2) move the data file,
> 3) alter database rename file,
> 4) online the TS

        It's much easier than that.

	Create a new undo tablespace wherever you want it. 
	Call it whatever you want to
	Alter your spfile/ini file to point to the new Undo TS.
	Restart instance.

	There's really no need to move the Undo tablespace. Just make

a new one and alter the relevant pointers.

[deletia]

-- 
     If you think that an 80G disk can hold HUNDRENDS of           |||
hours of DV video then you obviously haven't used iMovie either.  / | \

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com

Received on Fri Mar 10 2006 - 10:01:42 CST