Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_PDBS

DBA_PDBS describes PDBs belonging to a given CDB. When queried from the root, it will describe all PDBs belonging to a given CDB. When queried from a PDB, it will always return no rows.

Column Datatype NULL Description
PDB_ID NUMBER NOT NULL Container ID of the PDB
PDB_NAME VARCHAR2(128) NOT NULL Name of the PDB
DBID NUMBER NOT NULL PDB identifier calculated when the PDB is created and stored in all file headers associated with the PDB
CON_UID NUMBER NOT NULL Unique identifier associated with the container
GUID RAW(16)   Globally unique immutable ID assigned to the PDB at creation time
STATUS VARCHAR2(13)   State of the PDB. Possible values:
  • NEW - The PDB has never been opened since it was created. It must be opened in READ WRITE mode for Oracle to perform processing needed to complete the integration of the PDB into the CDB and mark it NORMAL. An error will be thrown if an attempt is made to open the PDB read only.

  • NORMAL - The PDB is ready to be used.

  • UNPLUGGED - The PDB has been unplugged. The only operation that can be performed on it is DROP PLUGGABLE DATABASE.

  • NEEDS UPGRADE - A PDB needs to be upgraded to the version of the CDB into which it was plugged.

  • CONVERTING - A non-CDB was plugged into the CDB and is undergoing conversion required to make it behave like a real PDB.

  • UNUSABLE - The PDB is being created or an unrecoverable error was encountered during its creation. The PDB cannot be opened while its state is set to UNUSABLE. If the PDB remains in this state because of an error encountered during its creation, it can only be dropped. The alert log can be checked to determine if there was an error during PDB creation.

CREATION_SCN NUMBER   Creation SCN
VSNFoot 1  NUMBER   The version number of the PDB
LOGGINGFootref 1 VARCHAR2(9)   Shows the current logging mode for the PDB. Possible values:
  • LOGGING

  • NOLOGGING

FORCE_LOGGINGFootref 1 VARCHAR2(3)   Specifies whether force logging is turned on for the PDB. Possible values:
  • NO

  • YES

FORCE_NOLOGGINGFootref 1 VARCHAR2(3)   Specifies whether force nologging is turned on for the PDB. Possible values:
  • NO

  • YES

CON_ID NUMBER NOT NULL The ID of the container that CON_DBID identifies. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


Footnote 1 This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).