Two things are involved here, migrating from one platform to another and migrating the database from 8.0.5 to 8.1.7
o For migrating the database across platform use export/import.
o For migration the database from Oracle8 to Oracle 8i use the migration script u0800050.sql (manually) or use the ODMA.
o Install Oracle8i on Solaris Box and do the migration of database.
o Here you can use ODMA or the upgrade script.
o Then Install Oracle8i on Linux Box and perform export/import from Solaris to Linux.
o Install Oracle8i on Linux Box.
o Export from Solaris Oracle8 using Oracle8 exp utility and import directly into Linux Oracle8i using Oracle8i imp utility.
o Here you dont need the upgrade script or ODMA as the database is being imported directly into Oracle8i.
I would go for the second one.
Amar "There is a difference between knowing the path and walking the path."
I doubt moving database from WinNT to Linux using coldbackup will work, *unless* you have put all files on FAT filesystem in NT and in Linux also you are putting those files on FAT filesystem.
The only method Oracle recoomends for cross-platform migration is EXPORT/IMPORT.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"