Requires Free Membership to View
If your database is too large to use the export/import method, you could try another approach, which would be to upgrade your 8i database (assuming it's 8.1.7.4) directly to Oracle 10g on the Solaris server, then use the new 10g cross-platform transportable tablespaces feature to move your database across to the Linux server. Both Solaris and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. Solaris is big endian while Linux is little endian, so there is an additional step involved to convert the tablespaces being transported on either the source or target side.
To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network. The guide can be found here.
This was first published in October 2005

Join the conversationComment
Share
Comments
Results
Contribute to the conversation