Re: Database Upgradation from 8.1.7 to 22.214.171.124
Importing 750G is not something to be taken likely.
As Mladen said, read up the docs on migration, upgrade, whatever
is called at the moment.
Then practice it, and document what you learned.
Then do it for real.
Certifiable Oracle DBA and Part Time Perl Evangelist
On 1/22/06, Prabhu, K <firstname.lastname@example.org> wrote:
Our client is planning to migrate their OLTP application from Oracle 8.1.7
to O9iR2. The current database size is 750 GB.
What is the best method to upgrade the database ?
1. Export/Import full database dump.
2. Coping all the 8i control files, data files and creating 9i database on
new box using the existing files.