5.236 DBA_PDB_SNAPSHOTS
DBA_PDB_SNAPSHOTS
describes all the snapshots for a given pluggable database (PDB).
Rows are added to this view when a snapshot of a PDB is taken by using the ALTER
PLUGGABLE
DATABASE
SNAPSHOT
SQL statement.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The ID of the PDB |
|
|
|
Unique ID assigned to the PDB at creation time |
|
|
|
Name of the PDB |
|
|
|
Snapshot name of the PDB |
|
|
|
SCN at which the snapshot was taken |
|
|
|
SCN at which the previous snapshot for the PDB was taken |
|
|
|
Timestamp at which the snapshot was taken |
|
|
|
Timestamp of the previous snapshot for this PDB |
|
|
|
Full path for the snapshot |
Note:
This view does not display snapshot copy PDBs, which are created by using the CREATE
PLUGGABLE
DATABASE
... SNAPSHOT
COPY
SQL statement.
Note:
This view is available starting with Oracle Database 18c.