DBA_PDB_SNAPSHOTFILE
DBA_PDB_SNAPSHOTFILE displays the files associated with snapshots taken of pluggable databases (PDBs).
You can use this view in conjunction with the DBA_PDB_SNAPSHOT view. Join the SNAPSHOT_SCN column in this view with the SNAPSHOT_SCN column in DBA_PDB_SNAPSHOT to determine the files associated with a particular PDB snapshot. A PDB snapshot consists of an archive log file, one or more data files, and one or more XML files. A row is added to this view for each file associated with a PDB snapshot.
| Column | Datatype | NULL | Description |
|---|---|---|---|
CON_ID |
NUMBER |
NOT NULL |
The ID of the PDB |
SNAPSHOT_SCN |
NUMBER |
NOT NULL |
SCN at which the snapshot was taken |
SNAPSHOT_FILENAME |
VARCHAR2(513) |
NOT NULL |
Snapshot file name |
SNAPSHOT_FILETYPE |
VARCHAR2(8) |
NOT NULL |
Snapshot file type. Possible values:
|
See Also: “DBA_PDB_SNAPSHOTS”