Skip to content

How to check & open PDB

The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).

A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.

The v$pdbs view is use with a pluggable database. 

select name,open_mode from v$pdbs;

Open the pluggable database:

SQL> alter pluggable database pdbhammer open;

Pluggable database altered.

SQL>

Link : https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/introduction-to-the-multitenant-architecture.html#GUID-267F7D12-D33F-4AC9-AA45-E9CD671B6F22

[the_ad id=’12166′]

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

Exit mobile version