Re: How do we shrink UNDO tbs in 9i ?
- From: Bala <oratips@xxxxxxxxx>
- To: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- Date: Fri, 16 Nov 2007 21:57:34 -0500
It worked -- No issues this time. Thanks for the email.
Regards
Bala --
On 11/16/07, Finn Jorgensen <finn.oracledba@xxxxxxxxx> wrote:
>
> I'm 98% sure that will work.
>
> The one caveat is that when you drop the undo1 tablespace you
> drastically increase the risk of ORA-1555's for a little while.
>
> Finn
>
> On Nov 16, 2007 3:11 PM, Bala <oratips@xxxxxxxxx> wrote:
> >
> >
> > Gurus,
> >
> > ORACLE 9.2.0.6 EE on Solaris
> >
> > Can I reduce the size of original undo tablespace (UNDO1) which has
> grown to
> > 15 GB due to heavy import activity, by creating a
> > second undo tablespace(UNDO2) and doing the following
> >
> > --
> > 1) alter system set undo_tablespace = UNDO2;
> > 2) Drop tablespace undo1 including contents and datafile;
> > 3) create original undo tablespace undo1 with small size
> > 4) alter system set undo_tablespace = UNDO1;
> > 5) drop the second undo tablespace ( UNDO2)
> > --
> > would this work for 9.2.0.6 ?
> >
> > Thanks for your time
> >
> > Bala --
> >
> >
> >
> > --
> > Bala Rao
>
--
Bala Rao
Other related posts:
