Post

Visualizzazione dei post da maggio, 2024

CLONE REMOTE PDB da un Container ad un altro usando DBLINK

--->>>>DOC  2882174.1 --- How to clone remote pdb from one cdb to another cdb using db link We are cloning the pluggable database, PDB1 from root container database, CDB1 to PDB2 in root container database, CDB2. a) Close and Open the PDB1 in READ WRITE mode to create cloneuser. SQL> alter pluggable database pdb1 close; Pluggable database altered. SQL> alter pluggable database pdb1 open; Pluggable database altered. Login to 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 session set container=PDB1; SQL> alter pluggable database close; SQ