Shulou(Shulou.com)06/01 Report--

Sys@newtestCDB > col restricted format A10

Sys@newtestCDB > col name format A20

Sys@newtestCDB > select v.name, v.open_mode, nvl (v.restricted, 'nmax 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

Elapsed: 00:00:00.02

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.