Sunday, September 18, 2016

Migrate 11g database as a pluggable database (PDB) to a 12c's 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. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

3. Create a new PDB in the target container database.

4. Copy the associated data files and export the dump file to the desired location in the target database.

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

6. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

No comments:

Post a Comment