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 the
pga_schema
metadata table where analytical tables are created.
snapshot_ID: The ID of the snapshot from
the pga_snapshot
metadata table.