How to Transfer, Move or Copy an Application or Schema or a Set of Schema's to a Different Database

(Doc ID 1938257.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Goal

The article is intended for the Database Administrator of the Oracle7, Oracle8, Oracle8i, Oracle9i, Oracle10g, Oracle11g, and Oracle12c databases who wish to use DataPump to copy or move an application or a schema or a set of schema's from a source database to a target database.

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

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