12c release has given us the ability to virtualize databases.   These procedure outlines three methods to move a stand-alone database to a 12c PDB.   Each of these methods have both positive and negatives aspects.  Careful thought, analysis and some testing should be performed before deciding which method is best for your situation.

 

 

Method 1 – DBMS_PDB package.

DBMS_PDB package is provided with Oracle 12c RDBMS release.  It provides multiple procedures for checking, preparing, creating conversions, and cleaning up after movement of standalone database to PDB.

 

Pros:

1. Removes guess work from conversion process.
2. No coding on administrators part.
3. No need to create PDB before procedure.

 

Cons:

1. No ability to transform data elements.

 

Method 2 – Data Pump

Use the EXP/IMP to extract metadata and data from standalone database into PDB.

 

Pros:

1. EXP/IMP utility of data pump are well known.
2. Able to do inclusive/exclusive data movement.
3. Able to start and stop.

 

Cons:

1. Have to build CDB and PDB for destination.
2. Can requires disk space for exports.
3. Can be very time consuming.

 

Method 3 – Goldengate / ETL technology

Use Goldengate or other ETL tool to move data from existing standalone into PDB.

 

Pros:

1. Can be done online with minimal down time.
2. Is extremely flexible.
3. Able to start and stop.
4. Able to transform data during process.

 

Cons:

1. Have to build CDB and PDB for destination.
2. Expensive licensing cost.
3. Can be time consuming.

 

 

 

Larry Catt

OCP