Re: 8i -> 10gR2 update

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

I prefer exp/imp because of the possibility of having a clean/neat database to start with. Sqlplus COPY is also a way to do it (just make sure nobody is changing the source database while you copy it :-)

Best wishes/vriendelijke groeten,
Andre van winssen

> Hi all,
> in the next weeks, I'll have to perform an update from 8.1.7.3 rel.
> directly to 10gR2, platform is Win2K sp4.
>
> On Oracle documentation, I found "Oracle Database Update Guide for 10g
> Rel. 2", this seems to be a good starting point, but are there any
> suggestions and caveats for this job?
>
> Furthermore, the specified doc says the update can be performed in
> different ways (DBUA, manual, export/import, data copying); according to
> your experience, what is the less troublesome method?
>
> Thanks for your help,
>
> Alessandro
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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