Examples: List the Tables in a Catalog, Including Their Owning Schemas

To list all tables within a specific schema (catalog) from the enabled catalogs, you can use:

SELECT OWNER, TABLE_NAME FROM ALL_TABLES@CATALOGNAME;
WHERE OWNER = '<SCHEMA_NAME>';

Here, ALL_TABLES is the table name.

For example, to list tables in the SH schema (a sample schema available in Oracle Autonomous Database):

SELECT OWNER, TABLE_NAME FROM ALL_TABLES@CATALOGNAME;
WHERE OWNER = 'SH';

This query returns all tables owned by the specified schema.

Note

In this example, you are listing tables in the SH schema of an external database.

Parent topic: Query Remote Catalogs and Databases