Re: 10G R2 / ASSM / DBUA or Exp/Imp

This interaction didn't go too well. I'll try again if anyone's up for it.

Is ASSM in 10G R2 much better than it was in 9i. Is it worth rebuilding my tablespaces for the upgrade?

Thanks. Ed.

> > On Fri, 13 Jul 2007 03:15:14 -0700, Ed_Zep wrote:
> > > I'm guessing that most of the bugs withASSMhave been sorted out now
>
> > I tried guessing the winning lottery numbers quite a few times and
> > I no longer trust my guesses.
>
> er...ok...
>
> > > but as we're upgrading from 9.2.0.8 quite soon, I was wondering if
> > > rather than using the DBUA tool it would be better to do the more
> > > tedious exp/imp and convert toASSMat the same time.
>
> I've not mentioned ASM... I putASSM(Automated Segment Space
> Management).
>
> > And how, exactly, do you plan on gettingOracle9i into ASM? RMAN will
> > not help you much there.
>
> By recreating the tablespaces and doing exp/imp?
>
> > > What's the current thinking reASSM? I like the idea of being able
> > > reclaim space but is it something that could prove to be more trouble
> > > than it's worth.
>
> >ASSMor ASM?
>
> ASSM, as I said...
>
> > > Also, when using DBUA on a test database I got a couple of ORA-06502 -
> > > PL/SQL: numeric or value errors but the database seemed fine with no
> > > invalid PL/SQL. Is that expected from DBUA?
> > Have you installed 10.2.0.3 patchset and CPU patches for April?
>
> 10.2.0.3 yes.
>
> Thanks!
>
> - Show quoted text -
Received on Tue Jul 17 2007 - 06:41:39 CDT