Re: steps to be followed for migrating data from 8.1.7 database to 9.2.0.5.0

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 18 Jun 2004 22:25:17 +1000
Message-ID: <40d2df12$0$18667$afc38c87@news.optusnet.com.au>

"Bhaskar" <bhaskarpallamala_at_yahoo.com> wrote in message news:b9cb248.0406180319.6dcfc9c7_at_posting.google.com...
> We have Oracle 8.1.7 installation containing 5 to 6 databases
> (instances).Now we need to move to 9i(9.2.0.5.0). As the documents and
> guide say that install 9.2.0.1.0 and apply oracle patch 3501955 which
> upgrades this base installation to 9.2.0.5.0, upto this everything
> looks fine. But for migrating the data what exactly need to be done.
> Each database might be of 8-10 GB. It would be more helpful if given
> more detailed explanation the ways to migrate data and the procedure.
> Thanks in advance.

There is an entire document supplied by Oracle concerning migrating to 9i from previous versions (available at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm if you haven't already found it). What exactly in it wasn't clear to you?

Regards
HJR Received on Fri Jun 18 2004 - 07:25:17 CDT