Ask the Expert

Moving an 8i/Solaris database to a 10g/Linux box

I have an existing Oracle 8i database on a Solaris 2.8 box that I MUST get to a Linux (Suse 9.3) Oracle 10g box. How can I get this database to the new machine without reinventing the wheel?

    Requires Free Membership to View

Because you are essentially upgrading your database and moving to a different platform all at once, I would recommend creating a new Oracle 10g database on your Linux server, exporting your 8i database and then importing it into the 10g database. This accomplishes two things at once: your database upgrade as well as the cross-platform move of your database.

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: