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.