Clone a PDB

When you want to clone a PDB (in the same CDB) then there few simple steps to do. Check your Database Parameters Connect to your CDB Stop the source PDB (hope this step will not be necessary in future releases) Clone the PDB Open the PDB Step 1: Check your Database Parameters We want to…

Convert a non PDB to a PDB

When you want to convert a Single Instanz (non PDB) to a PDB (for example after a pre 12c Database upgrade) then this example is usefull for you. First here is a overview of the task: Open the database in read only mode Create a xml File for the conversion Login into your CDB Plug…

12c New Feature: Datapump enhancements

Also Datapump has some new interesting New Feature which are usefull for tranporting your data. Creating SecureFile LOBs During Import You can now specify the LOB Storage during import Command line example: impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=export.dmp LOB_STORAGE:SECUREFILE Compressing Tables During Import You can now specify a Compression method during import Command line example: impdp scott/tiger…