39.1. Retrieving a Snapshot #
On the server with the metadata catalog, execute the following command:
SELECT * FROM axe_catalog.pga_snapshot WHERE snapshot_id = snapshot_ID;
Where snapshot_ID is the ID of the snapshot from the pga_snapshot metadata table.
To retrieve the latest snapshot, execute the following command:
SELECT * FROM axe_catalog.pga_snapshot WHERE snapshot_id = (SELECT max(snapshot_id) FROM axe_catalog.pga_snapshot);