meta données pour cette page
Différences
Ci-dessous, les différences entre deux révisions de la page.
| oracle:database:duplicate_pdb_to_same_cdb [30/09/2024 11:23] – créée mdl | oracle:database:duplicate_pdb_to_same_cdb [01/10/2024 08:08] (Version actuelle) – [Duplicate PDB to same CDB] mdl | ||
|---|---|---|---|
| Ligne 2: | Ligne 2: | ||
| ====== Duplicate PDB to same CDB ====== | ====== Duplicate PDB to same CDB ====== | ||
| + | * clone | ||
| <code PLSQL> | <code PLSQL> | ||
| create pluggable database pdb1_clone from pdb1; | create pluggable database pdb1_clone from pdb1; | ||
| - | alter pluggable database pdb1_clone open; | + | alter pluggable database pdb1_clone open [instance=all]; |
| + | </ | ||
| + | |||
| + | * check status | ||
| + | <code PLSQL> | ||
| + | set lines 200 | ||
| + | column name format a30 | ||
| + | select INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED | ||
| + | from gv$pdbs | ||
| + | where name=' | ||
| </ | </ | ||