28.3. Retrieving Analytical Tables #
Execute the following query:
SELECT table_id, table_name
FROM pga_table
WHERE
schema_id = schema_ID AND
snapshot_ID >= begin_snapshot AND
(snapshot_ID < end_snapshot OR end_snapshot IS NULL);
Where:
schema_ID: The ID of the analytical schema from thepga_schemametadata table where analytical tables are created.snapshot_ID: The ID of the snapshot from thepga_snapshotmetadata table.