[chrisplough]

Just a note, as we've been doing several OTM migrations to OTM v5.5 (from versions v5.0, v4.5 and v4.0):

I've had some issues with exporting from Oracle 9i and importing into Oracle 10g -- primarily around db objects that are invalid and never seem to get fixed. While this should work and I very much agree with Alan's post -- we've had to do the following:

- Upgrade from v4.5 to v5.0 on same database instance installed on Oracle 9i.
- Take a cold DB backup
- Upgrade from Oracle 9i to Oracle 10G version.
- Take a cold DB backup
- Upgrade to v5.5 by applying the dbupdate and dbmigrate scripts.
- Update to v5.5 CU3 (or CU2) by applying the dbupdate_55 script.
- Take a cold DB backup

I added the backups in - as we use these to give recovery points in case something goes wrong. Also note that I added in the dbpatch_55 script - as this is VERY important.

The largest issue you're likely to hit will be getting this all done within your migration window (usually a weekend). In this case, a super-fast DB server and performing pre-migration data purges helps tremendously.

Thanks,
--Chris