Default: the default database edition on the system
Purpose
Specifies the database edition from which objects will be exported.
Syntax and Description
SOURCE_EDITION=edition_name
If SOURCE_EDITION=
edition_name
is specified, then the objects from that edition are exported. Data Pump selects all inherited objects that have not changed and all actual objects that have changed.
If this parameter is not specified, then the default edition is used. 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 SOURCE_EDITION
parameter:
> expdp hr DIRECTORY=dpump_dir1 DUMPFILE=exp_dat.dmp SOURCE_EDITION=exp_edition EXCLUDE=USER
This example assumes the existence of an edition named exp_edition
on the system from which objects are being exported. Because no export mode is specified, the default of schema mode will be used. The EXCLUDE=user
parameter excludes only the definitions of users, not the objects contained within users' schemas.
Oracle Database SQL Language Reference for information about how editions are created
Oracle Database Development Guide for more information about the editions feature, including inherited and actual objects