Clonare un PDB remoto da un CDB a un altro CDB utilizzando il collegamento db
Valido da oracle 12. Collegarsi al cdb sorgente contenente il pdb da clonare SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED -------- ------------ -------------- -------------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO Il PDB1 deve essere in modalità READ WRITE SQL> alter pluggable database pdb1 close; Pluggable database altered. SQL> SQL> alter pluggable database pdb1 open; Pluggable database altered. Login to PDB1 container. i.e. PDB1 e creare l'utente cloneuser usato dal dblink creato su CDB2 SQL> alter session set container=pdb1; SQL> create user cloneuser identified by cloneuser; Grant create session and create pluggable database privileges to cloneuser. SQL> grant create session, create pluggable database to cloneuser; Controlla i privileges granted to the cloneuser. SQL> select * from dba_sys_privs where grantee = 'CLONEUSER'; Aprire PDB1 in modalità read only. SQL> alter