Ask the Expert

Using Data Pump to move a database from HP-UX to Linux

Because of the high cost of HP-UX machines, we plan to upgrade and move our current 9i (9.2.0.4) database to 10g on a Linux platform. The current production database is about 200GB, and using imp/exp may take a long time in Oracle9i. Therefore, we are considering upgrading the 9i database directly to 10g on its original platform and then using the new feature of Data Pump to move the database from HP-UX to the Linux machine. Please advise whether this approach is applicable and how long it may take to use Data Pump on a 200GB database. Thank you very much.

    Requires Free Membership to View

Your plan to upgrade your database in place to 10g and then use Data Pump to migrate to another platform is a very good plan. In almost all test results I've seen, Data Pump is considerably faster than using export/import, although I cannot say how long this process will take since it is dependent on hardware and the type of data contained in your database.

Another option you may want to consider, if you're going to migrate in place, is the Oracle 10g cross-platform transportable tablespace feature. This feature will allow you to migrate from one platform to another. If you are running HPUX 11.0, 11.11 or 11.23 you can install Oracle 10gR2 on your HPUX server, upgrade your database in place, and then use the new cross-platform transportable tablespaces feature to move your database to your Linux server. Both HPUX and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. HPUX 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.

You should also review the Oracle Database 10g Release 2 (10.2) Upgrade Guide.

This was first published in May 2006

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: