Is there a way to identify snapshot PDB when mounted?
Hello Everyone,
When I create snapshot pluggable database:
When I create snapshot pluggable database:
create pluggable database PDB2 from PDB snapshot copy file_name_convert=('/pdb/','/pdb2/'); Pluggable database created.I cannot find any relevant information, that the created database was of snapshot type, when the PDB is in mounted state:
col name for a15 select con_id,name,open_mode, snapshot_parent_con_id from v$pdbs; CON_ID NAME OPEN_MODE SNAPSHOT_PARENT_CON_ID ---------- --------------- ---------- ---------------------- 2 PDB$SEED READ ONLY 4 PDB2 MOUNTED 5 PDB1 READ ONLY
The column SNAPSHOT_PARENT_CON_ID gets populated only when you open the PDB:
0