On the server with the metadata catalog, execute the following command:
SELECT table_id, table_name FROM axe_catalog.pga_table WHERE schema_id =schema_IDANDsnapshot_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 that contains analytical tables.
snapshot_ID: The ID of the snapshot from
the pga_snapshot
metadata table.