Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 8i -> 10gR2 update

Re: 8i -> 10gR2 update

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Tue, 20 Jun 2006 13:21:56 -0400
Message-ID: <44982EB4.2060407@tufts.edu>


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
Received on Tue Jun 20 2006 - 12:21:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US