My Oracle Support Banner

How to Perform a Full Database Export Import During Upgrade, Migrate, Copy or Move of a Database (Doc ID 286775.1)

Last updated on JULY 02, 2023

Applies to:

Oracle Database - Personal Edition - Version 8.1.7.0 to 12.1.0.2 [Release 8.1.7 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.5.0 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 18.3.0.0.0 [Release 10.1 to 18]
Oracle Database - Personal Edition - Version 10.1.0.2 to 18.3.0.0.0 [Release 10.1 to 18]
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 18.3.0.0.0 [Release 8.1.7 to 18]
Information in this document applies to any platform.

Purpose

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.

Scope

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)

Oracle EBS 12.1 and 12.2:
<Note 2615617.1> Export/Import Process for Oracle E-Business Suite Release 12.1 Database Instances Using Oracle Database 19c (Doc ID 2615617.1)
<Note 2554156.1> Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c (Doc ID 2554156.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


Details

To view full details, 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 a vibrant support community of peers and Oracle experts.