23 lines
768 B
SQL
23 lines
768 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/18c/pdb_snapshots.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays the snapshots for all PDBs.
|
|
-- Requirements : Access to the CDB views.
|
|
-- Call Syntax : @pdb_snapshots
|
|
-- Last Modified: 01/01/2019
|
|
-- -----------------------------------------------------------------------------------
|
|
SET LINESIZE 150 TAB OFF
|
|
|
|
COLUMN con_name FORMAT A10
|
|
COLUMN snapshot_name FORMAT A30
|
|
COLUMN snapshot_scn FORMAT 9999999
|
|
COLUMN full_snapshot_path FORMAT A50
|
|
|
|
SELECT con_id,
|
|
con_name,
|
|
snapshot_name,
|
|
snapshot_scn,
|
|
full_snapshot_path
|
|
FROM cdb_pdb_snapshots
|
|
ORDER BY con_id, snapshot_scn;
|