User Tools

Site Tools


database:oracle:pluggable-database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revisionBoth sides next revision
database:oracle:pluggable-database [2019/01/09 12:31] – created odeftadatabase:oracle:pluggable-database [2019/01/09 12:46] odefta
Line 30: Line 30:
  
   alter pluggable database all save state;   alter pluggable database all save state;
 +  
 +===== Show all pluggable databases status =====
 +
 +<code sql>
 +
 +col NAME for a10
 +select name, open_mode from v$pdbs;
 +
 +NAME       OPEN_MODE
 +---------- ----------
 +PDB$SEED   READ ONLY
 +FLPDB      READ WRITE
 +
 +</code>
 +
 +
  
database/oracle/pluggable-database.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1