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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.