Re: Migrating 8i database to 9i

I'd suggest follwing option supposed we are not talking about a terabyte database:
exp your 8i database (full=y) using 8i exp tool install 9i and create the database you want including the tablespaces you had in the old database.
imp your 8i .dmp file using imp from 9i. (maybe only the schema's you want to migrate)

Hth,
Andre van Winssen

"damorgan" <damorgan_at_exesolutions.com> wrote in message news:3C903FD9.5BA5CCDA_at_exesolutions.com...
> Hold me back. Please Sybrand ... hold me back.
>
> By reading the installation instructions on the CD and following them.
>
> Daniel Morgan
> PS: Sorry ... I just couldn't resist. And it is truly all the advice you
> need without telling us what platform, what operating system, how large,
> how many users, or countless other little things that might allow a useful
> answer.
>
>
>
>
> JK Nidhi wrote:
>
> > Can someone suggest the best way to migrate an oracle 8i database to 9i
> >
> > thanks
>
Received on Thu Mar 14 2002 - 02:46:17 CST