We plan on migrating from 7.2.3 to 8.0.3 in the next month and have
approximately 1 month allocated to perform the migration. We have 1
production and 4 test instances to migrate.
I would be interested to hear which migration strategy other Oracle
customers have taken, why and what your experience was.
We do not plan on exploiting any of the new features supplied with Oracle8
at this time as we do not feel we can migrate, investigate and implement
the new features in a one month time frame.
2 gigs memory
33 GB of data
If we choose the Export/Import route we predict an elapsed time of about 36
hours to complete just the Export/Import. Our largest table consumes
330,000 8k blocks.