ANIL VEJENDLA

Create test pdb called s24pdb: SQL> create pluggable database s24pdb admin user s24test identified by ****; Pluggable database created. SQL> alter pluggable database S24PDB open; Pluggable database altered. SQL> sho pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 TEST1                          READ WRITE NO          5 S24PDB                         READ WRITE NO SQL> alter pluggable database S24PDB close; Pluggable database altered. SQL> alter pluggable database S24PDB open restricted; Pluggable database altered. SQL> sho pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 TEST1                          READ WRITE NO          5 S24PDB     

RELOCATE PDB IN ORACLE 12.2 Prerequisite : Local Undo should be enabled on both Source and Target CDB's. Both Databases should be in archivelog mode. Source CDB: ========== COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 SELECT property_name, property_value FROM   database_properties WHERE  property_name = 'LOCAL_UNDO_ENABLED'; PROPERTY_NAME                  PROPERTY_VALUE ------------------------------ ------------------------------ LOCAL_UNDO_ENABLED             TRUE SQL> SELECT log_mode FROM   v$database; LOG_MODE ------------ ARCHIVELOG CREATE USER c##remote_clone_user IDENTIFIED BY remote_clone_user CONTAINER=ALL; GRANT CREATE SESSION, SYSOPER, CREATE PLUGGABLE DATABASE TO c##remote_clone_user CONTAINER=ALL; Target CDB: ========== COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 SELECT property_name, property_value FROM   database_properties WHERE  property