database:oracle:pluggable-database
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
database:oracle:pluggable-database [2019/01/09 12:31] – created odefta | database: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 | ||
+ | ---------- ---------- | ||
+ | PDB$SEED | ||
+ | FLPDB READ WRITE | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
database/oracle/pluggable-database.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1