How To Use Export And Import When Transferring Data Across Platforms Or Across 32-bit And 64-bit Servers

(Doc ID 277650.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Personal Edition - Version 8.1.7.0 to 10.2.0.1 [Release 8.1.7 to 10.2]
Oracle Database - Standard Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2014***

Goal

This document provides the concepts how the export and import utilities can be used to transfer data, schemas, tablespaces, databases across platforms and across 32-bit/64-bit processor servers.

The document is limited to the usage of the Export and Import utilities, and does not give detailed information about the following upgrade or migrate procedures:
- upgrade of the Operating System (e.g. move from HP-UX 10.20 to HP-UX 11.0)
- upgrade of the hardware (e.g. move from 32-bit to 64-bit)
- upgrade of Oracle Software (e.g. move from Oracle9i 9.2.0.8.0 to Oracle10g 10.2.0.3.0)

For details about those procedures, see the Knowledge Browser in MetaLink:
- Tab:   Knowledge - Knowledge Browser
- Product:   Database - Installation, Upgrade and Migration.

Note:
In principle the information also applies to Oracle 11g. However, as of Oracle 10g, the Oracle DataPump (expdp/impdp) is preferred above the traditional exp/imp utilities.
Original Export is desupported for general use as of Oracle Database 11g. The only supported use of original Export in Oracle Database 11g is backward migration of XMLType data to Oracle Database 10g release 2 (10.2) or earlier. Therefore, Oracle recommends that you use the new Data Pump Export and Import utilities
Please refer to:
http://docs.oracle.com/cd/E16655_01/server.121/e17639/original_export.htm#SUTIL3634

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms