39.3. Retrieving Analytical Tables #
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 thepga_schemametadata table that contains analytical tables.snapshot_ID: The ID of the snapshot from thepga_snapshotmetadata table.