meta données pour cette page
Ceci est une ancienne révision du document !
Source
- cdb TSTTDECL
- with wallet password : pwdtsttdecl
- pdb PDB1TDE
- with wallet password : pwdpdb1tde –isolated mode
Target
- cdb TARTDECL
- with wallet password : pwdtartdecl
- pdb PDBTARTDE
- with wallet password : pwdpdbtartde –isolated
1/ Log in to the source isolated mode PDB PDB1TDE and verify that the wallet is opened
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB1TDE READ WRITE NO SQL> SELECT CON_ID, KEYSTORE_MODE,status,wallet_type FROM gV$ENCRYPTION_WALLET; CON_ID KEYSTORE STATUS WALLET_TYPE ---------- -------- ------------------------------ -------------------- 3 ISOLATED OPEN PASSWORD
2/ On target CDB TARTDECL create a database link for the PDB PDB1TDE that you want to clone remotely.
SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> CREATE database link forclone CONNECT TO system identified BY ZicZac##4523Pec using '//moros:1521/PDB1TDE.COE.CORP'; Database link created. SQL> ALTER session SET global_names=FALSE; Session altered. SQL> SELECT * FROM dual@forclone; D - X SQL>