39.2. Retrieving Analytical Schemas #
On the server with the metadata catalog, execute the following command:
SELECT schema_id, schema_name FROM axe_catalog.pga_schema WHEREsnapshot_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.