DB Wiki

This is an old revision of the document!

Multitenant Architecture

Opening / Closing Pluggable Databases

SQL> alter session set container = pdb2;

Session altered.

SQL> shutdown 
Pluggable Database closed.
SQL> startup
Pluggable Database opened.
SQL> alter pluggable database pdb2 close;

Pluggable database altered.

SQL> alter pluggable database pdb2 open;

Pluggable database altered.

I think it always safer to use the “alter pluggable” command so you definitely know which database you are closing.