Ask the Expert

Migrating to a different Endian format

You say that when migrating Oracle from Windows to Solaris, you should precreate the database and tablespace on Solaris and use the imp utility to import all tablespaces from the Windows host. What about Endian format? They are different. You didn't mention this. Please advise.

    Requires Free Membership to View

It is true that the Endian-ness of Windows and Solaris platforms are different. But the Endian-ness only applies when using Transportable Tablespaces to copy data from one Oracle database to another. I was referring to traditional export/import methods, which create a platform-neutral dump file. The Endian-ness does not come into play here. If you do choose to use Transportable Tablespaces, which is a very valid option for moving data, then you will have to change the Endian format during the move. The Oracle Utilities Guide has further details.

This was first published in February 2007

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: