Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: 8i -> 10gR2 update

Joe Armstrong-Champ

2006-06-20

Replies:

Andre,

I noticed that you made note of not having any LONG columns. Is there a
problem with LONG columns when using this procedure?

Thanks.
Joe

Andre van Winssen wrote:
> Hi Alessandro,
>
> we just did a mig of 8.1.7.4 to 10.2.0.2 using exp/imp. The export files
> were 100Gb in total. No tables with LONG type columns and millions of rows
> so the import finished rather smoothly in 24 hours (Win2K sp4/8CPU/8Gb)
> I noticed thast the STATS were locked after the import in 10.2 so I
> unlocked them by calling dbms_stats.unlock_schema_stats()
>
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.