How to Perform a Full Database Export Import During Upgrade, Migrate, Copy or Move of a Database
(Doc ID 286775.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Personal Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 126.96.36.199.0 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 188.8.131.52.0 [Release 10.1 to 18]
Oracle Database - Personal Edition - Version 10.1.0.2 to 184.108.40.206.0 [Release 10.1 to 18]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168.0 [Release 8.1.7 to 18]
Information in this document applies to any platform.
This article describes how to run a full database export on a source database and how to import the export dump file into a target database.
The article is intended for the Database Administrator of the Oracle7, Oracle8, Oracle8i, Oracle9i, Oracle10g, Oracle11g, and Oracle12c databases who wish to use DataPump or the EXPORT and IMPORT utilities to perform a full database export from an Oracle database release x and import this data with a full database import into an Oracle database release y.
The steps provided in this article do not apply to the export and import or Oracle Applications databases. For Oracle E-Business Suite database, there is a separate procedure. See the following documents:
Oracle EBS 11i:
<Note 230627.1> - 9i Export/Import Process for Oracle Applications Release 11i
<Note 331221.1> - 10g Export/Import Process for Oracle Applications Release 11i
<Note 362205.1> - 10g Release 2 Export/Import Process for Oracle Applications Release 11i
<Note 557738.1> - Export/import notes on Applications 11i Database 11g
<Note 1585257.1> - Export/Import Process for EBS 11i on RDBMS 12c
Oracle EBS 12.0 and 12.1:
<Note 454616.1> - Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2
<Note 741818.1> - Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2
Oracle EBS 12.2:
<Note 1613716.1> - Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 11.2 (Doc ID 1613716.1)
The steps provided in this article also do not apply to the export and import of other specific schemas's for which there are separate procedures. See the following documents:
<Note 1439066.1> - Exporting/Importing in Oracle Portal 11g
<Note 1359656.1> - OIM 11gR1: Schema Backup and Restoration using Data Pump Client Utility
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!