Default: the default database edition on the system
Purpose
Specifies the database edition into which objects should be imported.
Syntax and Description
TARGET_EDITION=name
If TARGET_EDITION=
name
is specified, then Data Pump Import creates all of the objects found in the dump file. Objects that are not editionable are created in all editions. For example, tables are not editionable, so if there is a table in the dump file, then it will be created, and all editions will see it. Objects in the dump file that are editionable, such as procedures, are created only in the specified target edition.
If this parameter is not specified, then the default edition on the target database is used, even if an edition was specified in the export job. If the specified edition does not exist or is not usable, then an error message is returned.
Restrictions
This parameter is only useful if there are two or more versions of the same versionable objects in the database.
The job version must be 11.2 or later. See "VERSION".
Example
The following is an example of using the TARGET_EDITION
parameter:
> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=exp_dat.dmp TARGET_EDITION=exp_edition
This example assumes the existence of an edition named exp_edition
on the system to which objects are being imported. Because no import mode is specified, the default of schema mode will be used.
Oracle Database SQL Language Reference for information about how editions are created
Oracle Database Development Guide for more information about the editions feature