application common object
application common user
ALTER PLUGGABLE DATABASE APPLICATIONstatement.
CREATE PLUGGABLE DATABASEstatement.
ALTER PLUGGABLE DATABASE APPLICATIONstatement.
A database administrator who manages a CDB. A PDB administrator manages individual PDBs within the CDB.
CDB restore point
In a multitenant container database (CDB), a collection of schemas, schema objects, and nonschema objects to which all PDBs belong. Every CDB has exactly one root container, which stores the system metadata required to manage PDBs. All PDBs belong to the CDB root.
clean restore point
In a multitenant container database (CDB), a database user that exists with the same identity in multiple containers. A common user created in the CDB root has the same identity in every existing and future PDB. A common user created in an application container has the same identity in every existing and future application PDB in this application container.
In a multitenant container database (CDB), either the root or a PDB.
container data object
In a CDB, a table or view containing data pertaining to multiple containers and possibly the CDB as a whole, along with mechanisms to restrict data visible to specific common users through such objects to one or more containers. Examples of container data objects are Oracle-supplied views whose names begin with
In a CDB, a DDL statement that affects the CDB itself, multiple containers, multiple common users or roles, or a container other than the one to which the user is connected. Only a common user connected to the root can perform cross-container operations.
In a PDB, an internal mechanism that points to data (not metadata) in the root. For example, AWR data resides in the root. Each PDB uses an object link to point to the AWR data in the root, thereby making views such as
DBA_HIST_BASELINE accessible in each separate container.
The general process of moving data from one or more non-CDBs into a multitenant container database (CDB).
data-linked common object
extended data-linked common object
A hybrid of a data-linked common object and a metadata-linked common object. For an extended data-linked object, each application PDB can create its own PDB-specific data while sharing the common data in the application root.
In a PDB, an internal mechanism that points to a dictionary object definition stored in the root. For example, the
OBJ$ table in each PDB uses a metadata link to point to the definition of
OBJ$ stored in the root.
metadata-linked common object
The architecture that enables an Oracle database to function as a multitenant container database (CDB), which means that it can contain multiple PDBs. A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a traditional Oracle database (non-CDB).
multitenant container database (CDB)
An Oracle database that is not a multitenant container database (CDB). Before Oracle Database 12c, all databases were non-CDBs. Starting in Oracle Database 12c, every database must be either a CDB or a non-CDB.
A database administrator who manages one or more PDBs. A CDB administrator manages the whole CDB.
PDB archive file
A compressed file that contains both PDB data files and an XML metadata file. You can create a PDB by specifying the archive file, and thereby avoid copying the XML file and the data files separately.
PDB lockdown profile
A security mechanism to restrict operations that are available to local users connected to a specified PDB. A typical use is to limit the effect of a grant privilege. For example, you limit the grant of
ALTER SYSTEM to only those options whose names begin with
PDB performance profile
PDB restore point
Within a CDB, a restore point that usable only for a specific PDB. In contrast, a CDB restore point is usable by all PDBs.
PDB/non-CDB compatibility guarantee
In the multitenant architecture, the guarantee that a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net.
pluggable database (PDB)
A PDB that references a PDB in a remote CDB using a database link. The remote PDB is called a referenced PDB.
The PDB that is referenced by a proxy PDB. A local PDB is in the same CDB as its referenced PDB, whereas a remote PDB is in a different CDB.
refreshable clone PDB
A read-only clone that can periodically synchronize with its source PDB. Depending on the value in the
REFRESH MODE clause, the synchronization occurs either automatically or manually.
A container for resource plan directives that specify how resources are allocated to resource consumer groups.
resource plan directive
A set of limits and controls for CPU, physical I/O, or logical I/O consumption for sessions in a consumer group.
In a multitenant container database (CDB), a default pluggable database (PDB) that the system uses as a template for user-created PDBs. A PDB seed is either the system-supplied
PDB$SEED or an application seed.
shared undo mode
snapshot copy PDB
SNAPSHOT COPYclause. When creating a snapshot copy, Oracle Database does not make a complete copy of the source data files. Rather, Oracle Database creates a storage-level snapshot of the underlying file system, and then uses the snapshot to create PDB clones. Unlike a standard clone PDB, a snapshot copy PDB cannot be unplugged from the CDB root or plugged in to an application root.