Ask the Expert

How to perform a Big to Little Endian conversion in Oracle 8i

I want to transfer an Oracle-Database from a Solaris Big Endian 8.1.7i version to a Windows machine running the same database version but with Little Endian. I searched for hours, but I only find instructions using the Data Pump or XTTS. I don't think these technologies are available in Oracle 8i. Can you help me with this?

    Requires Free Membership to View

Since you are on Oracle 8i, you cannot use Transportable Tablespaces (TTS) for the endian conversion. You have two choices. Upgrade to Oracle 9i so that you can use TTS or use Oracle's export/import utilities. For more information on these utilities, refer to the 8i Utilities Guide. Chapter 1 will tell you how to use export and Chapter 2 tells you how to use import. So there are only 2 chapters to read to understand these utilities.

This was first published in December 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: