28.2. Retrieving Analytical Schemas #
Execute the following query:
SELECT schema_id, schema_name
FROM pga_schema
WHERE
snapshot_ID >= begin_snapshot AND
(snapshot_ID < end_snapshot OR end_snapshot IS NULL);
Where snapshot_ID is the ID of the snapshot from the pga_snapshot metadata table.