Re: Oracle 8i ----> 9i Upgrade on Solaris

danek wrote:

>Why does everyone want to move the data? Why not just simply upgrade the
>thing as and where it is? Both faster and simpler.
>
>
>

You wrote: In migration from 8.1.6 Standard to 9i Enterprise it is the onlny way...?

And I'd really like to know where that idea came from because it is absolutely untrue.

Go to $ORACLE_HOME/rdbms/admin.

Open the file u0801070.sql

Read the description. Heck I'll save you the trouble:

Rem     This script is to be used for upgrading an 8.1.6 database to the
Rem     new release.  This script provides a direct upgrade path from 8.1.6
Rem     to the new Oracle release.

Taken from my 9.2.0.4 install.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)