Re: 8i -> 10gR2 update

  • From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
  • To: awinssen@xxxxxxxxx
  • Date: Tue, 20 Jun 2006 13:21:56 -0400

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()

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2006