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

From: Ed_Zep <ed_zep_at_ntlworld.com>
Date: Fri, 13 Jul 2007 08:56:38 -0700
Message-ID: <1184342198.290607.72970@q75g2000hsh.googlegroups.com>

On Jul 13, 3:16 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> On Fri, 13 Jul 2007 03:15:14 -0700, Ed_Zep wrote:
> > I'm guessing that most of the bugs with ASSM have 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 to ASSM at the same time.

I've not mentioned ASM... I put ASSM (Automated Segment Space Management).

> And how, exactly, do you plan on getting Oracle 9i into ASM? RMAN will
> not help you much there.

By recreating the tablespaces and doing exp/imp?

> > What's the current thinking re ASSM? I like the idea of being able
> > reclaim space but is it something that could prove to be more trouble
> > than it's worth.
>
> ASSM or 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!

> --http://www.mladen-gogala.com
Received on Fri Jul 13 2007 - 10:56:38 CDT