---
title: "How to get list of table names in different schema of an Oracle database"  
description: "How to get list of table names in different schema of an Oracle database"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159128/how-to-get-list-of-table-names-in-different-schema-of-an-oracle-database  
category: "oracle"  
tags: ["database", "database schema", "oracle"]  
reading_time: 2 minutes  

---

# How to get list of table names in different schema of an Oracle database

How to get list of [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) names in different [schema](https://www.mindstick.com/articles/1844/how-schema-markup-useful-in-serp) of an [Oracle database](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)

## Replies

### Reply by Aryan Kumar

Sure, here is how you can get the list of tables names in different schemas of an [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle) [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax):

SQL

```plaintext
SELECT table_name
FROM all_tables
WHERE owner IN ('schema_name1', 'schema_name2', 'schema_name3');
```

This query will first select all tables from the `all_tables` view. The `all_tables` view is a data dictionary view that contains information about all of the tables in the database.

The next part of the query uses the `IN` operator to check if the owner of each table in the `all_tables` view is equal to one of the specified schemas. The `IN` operator takes a list of values as its argument. In this case, the list of values is the list of schemas that you want to list the tables for.

If the `IN` operator returns `TRUE` for a table, then the table in the `all_tables` view belongs to one of the specified schemas.

The final part of the query selects the `table_name` column from the `all_tables` view for all tables that belong to one of the specified schemas.

To run this query, you will need to connect to the Oracle database using a tool like SQL*Plus. Once you are connected, you can run the query by typing it into the SQL*Plus prompt.

For example, to run the query above, you would type the following into the SQL*Plus prompt:

SQL

```plaintext
SELECT table_name
FROM all_tables
WHERE owner IN ('schema_name1', 'schema_name2', 'schema_name3');
```

This would return a list of all tables in the specified schemas.


---

Original Source: https://www.mindstick.com/forum/159128/how-to-get-list-of-table-names-in-different-schema-of-an-oracle-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.