Ask the Expert

Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces

What is the best methodology for migrating an Oracle 9i 11.5 TB database from HP-UX to Sun Solaris as an Oracle 10g 11.5 TB database?

We have Veritas Filesystem (VxFS) on HP-UX. So, if we use the same Veritas Filesystem, will there be any issue?

    Requires Free Membership to View

Probably the best method for moving such a large DB from one OS to another is to leverage Oracle's Transportable Tablespaces (TTS) for the move. The file system does not matter. For more information on the TTS feature, consult the Oracle 10g Administrator's Guide, specifically the chapter on Managing Tablespaces.

This was first published in September 2009

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: