5.238 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:

  • ARCH: Archive log file

  • DATA: Data file

  • XML: XML file

Note:

This view is available starting with Oracle Database release 19c, version 19.1.

See Also:

"DBA_PDB_SNAPSHOTS"