5.238 DBA_PDBS
DBA_PDBS
describes PDBs belonging to a given CDB.
When queried from the root, DBA_PDBS
will describe all PDBs belonging to a given CDB. When queried from a CDB root, it will describe all PDBs that belong to the given CDB. When queried from an application root, it will describe all PDBs that belong to the given application container. When queried from a regular PDB or from an application PDB, it will describe the regular PDB or the application PDB.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Container ID of the PDB |
|
|
|
Name of the PDB |
|
|
|
PDB identifier calculated when the PDB is created and stored in all file headers associated with the PDB |
|
|
|
Unique identifier associated with the container |
|
|
|
Globally unique immutable ID assigned to the PDB at creation time |
|
|
|
State of the PDB. Possible values:
|
|
|
|
Creation SCN |
|
|
|
The version number of the PDB |
|
|
|
Shows the current logging mode for the PDB. Possible values:
|
|
|
|
Specifies whether force logging is turned on for the PDB. Possible values:
|
|
|
|
Specifies whether force nologging is turned on for the PDB. Possible values:
|
|
|
|
Indicates whether the PDB is an application root. |
|
|
|
Indicates whether a PDB is an application PDB |
|
|
|
Indicates whether a PDB is an application seed (an application seed is also an application PDB) |
|
|
|
If this PDB is an application PDB, the container ID of an application root to which this application PDB belongs. If this PDB is an application root clone, the container ID of an application root to which this application root clone belongs. Otherwise, NULL. |
|
|
|
Indicates whether this PDB is a proxy PDB |
|
|
|
The ID of the container that
|
|
|
|
The upgrade priority of the PDB. |
|
|
|
Indicates whether this PDB is an application root clone ( |
|
|
|
The foreign CDB’s DBID |
|
|
|
SCN at which the PDB was unplugged |
|
|
|
The foreign PDB ID |
|
|
|
PDB creation timestamp |
|
|
|
PDB refresh mode. Possible values:
|
|
|
|
PDB refresh interval. This is applicable only when |
|
|
|
For internal use only |
|
|
|
System change number (SCN) of the last refresh operation |
|
|
|
Pluggable database tenant key |
|
|
|
Pluggable database snapshot mode |
|
|
|
Pluggable database snapshot interval, in minutes |
|
|
|
Credential object name associated with the PDB |
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.