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 ...

Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial