5.237 DBA_PDB_SNAPSHOTS

DBA_PDB_SNAPSHOTS describes the snapshots taken of pluggable databases (PDBs).

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

CON_ID

NUMBER

NOT NULL

The ID of the PDB

CON_UID

NUMBER

NOT NULL

Unique ID assigned to the PDB at creation time

CON_NAME

VARCHAR2(128)

NOT NULL

Name of the PDB

SNAPSHOT_NAME

VARCHAR2(128)

NOT NULL

Snapshot name of the PDB

SNAPSHOT_SCN

NUMBER

NOT NULL

SCN at which the snapshot was taken

PREVIOUS_SNAPSHOT_SCN

NUMBER

NOT NULL

SCN at which the previous snapshot for the PDB was taken

SNAPSHOT_TIME

NUMBER

NOT NULL

Timestamp at which the snapshot was taken

PREVIOUS_SNAPSHOT_TIME

NUMBER

NOT NULL

Timestamp of the previous snapshot for this PDB

FULL_SNAPSHOT_PATH

VARCHAR2(4000)

NOT NULL

Full path for the snapshot

See Also: