sys@newtestCDB> col restricted format A10 sys@newtestCDB> col name format A20 sys@newtestCDB> select v.name, v.open_mode, nvl(v.restricted, ‘n/a‘) "RESTRICTED", d.status 2 from v$PDBs v inner join dba_pdbs d 3 using (GUID) 4 order by v.create_scn 5 /
NAME OPEN_MODE RESTRICTED STATUS
PDB$SEED READ ONLY NO NORMAL PDBTEST READ WRITE NO NORMAL CLONEPDB_PLUG READ WRITE NO NORMAL
