Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Container and Pluggable databases – Part5

Container and Pluggable databases Part5

0 Comments

  

Create a pluggable database clone from existing pluggable database in different CDB

Source CDB: CDB1
Source PDB: Anuj
Target CDB: CDB2
Target PDB: Mohan

Procedure:


Connect to CDB1 and place Anuj in read only mode

Connect to CDB2 as sys and run clone command

SQL>create pluggable database mohan from anuj@CDB2_dbl** admin user sys identified by

          sys_pwd file_name_convert = (/u01/pdbs/anuj,/u01/pdbs/mohan);

SQL> alter pluggable database Mohan open;

if using a common user you need to grant "create pluggable database" container=all

Endian format, character set, etc. must be compatible between CDBs

**  CDB2_dbl is database link used for communication between CDB1 and CDB2

  
Posted on : 5/13/2015 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Checking database patch level
Posted on :   11/2/2017

Finding database home information in database
Posted on :   10/10/2017

Beginner to Exadata?
Posted on :   8/31/2017

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c