Upgrade from 8.1.7.3 to 9.2.0.3 on Solaris 8
Has anybody encountered any issue regarding upgrading from 8.1.7.3 to 9.2.0.3? My boss does not want to spend the time on testing the upgrade (I thought I definitely should), so I try to avoid any known issues.
Also, when running DB upgrade assistant, if I have a 8i DB with 10GB, do I need to ensure I have at least 10GB free space available for it to use as temp storage? In other words, does it convert the DB on the spot or convert by copying/modifying piece by piece?
thanks,
Re: Upgrade from 8.1.7.3 to 9.2.0.3 on Solaris 8
I suggest not using the assistant with that 10G DB. Make an empty 9.2 DB, create the tablespaces, users, grant them their priveleges, export the 8i DB and import into 9i.
I have done about 50 upgrades this way.