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?
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.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.