10G R2 / ASSM / DBUA or Exp/Imp

From: Ed_Zep <ed_zep_at_ntlworld.com>
Date: Fri, 13 Jul 2007 03:15:14 -0700
Message-ID: <1184321714.778464.245610@o61g2000hsh.googlegroups.com>

I'm guessing that most of the bugs with ASSM have been sorted out now 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.

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.

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?

Thanks in advance,
Ed. Received on Fri Jul 13 2007 - 05:15:14 CDT