-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle Database 12c Backup and Recovery Survival Guide

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...
Change the font size
Change margin width
Change background colour