Using SOURCE_EDITION and TARGET_EDITIONS

With the introduction in Oracle 11gR2 of editions (Edition-Based Redefinition) that allow us to play with different versions (editions) of an object in an Oracle Database, Data Pump was forced to introduce new parameters to allow us to work within different editions available in the database. The parameters introduced were:

• SOURCE_EDITION to be used within expdp

• TARGET_EDITIONS to be used within impdp

A good example of the use of these new parameters is when we have multiple versions (editions) of an object in our development environment for different releases of an application, and we want to migrate a code from one version to a different version within a database or even across multiple databases.

In the following example, we will migrate a view (from our development database) called TEST from the schema TEST in the edition called NEW_EDITION to our production database schema TEST and to the edition called ORA$BASE:

$ expdp fcomunoz/alvarez@pdbdevorcl...