Prev Question
Next Question

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container
database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the
expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the
DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

A.
2, 1, 3, 4, 5, 6

B.
1, 3, 4, 5, 6, 7

C.
1, 4, 3, 5, 6, 7

D.
2, 1, 3, 4, 5, 6, 7

E.
1, 5, 6, 4, 3, 2

Explanation:
1. Set user tablespaces in the source database to READ ONLY.
2. From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing
in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS
parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database
llg Release 2 database:
3. Copy the tablespace data files from the source system to the destination system. Note that the log file from
the export operation will list the data files required to be moved.
4. Create a COB on the destination system, including a PDB into which you will import the source database.
5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act
of importing the dump file will plug the tablespace data files into the destination PDB
Oracle White Paper – Upgrading to Oracle Database 12c -August 2013

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *