Find Oracle Tablespace for Table

To check the tablespace corresponding to a table in the Oracle database, you can execute the following SQL query.

SELECT table_name, tablespace_name 
FROM user_tables
WHERE table_name = 'YOUR_TABLE_NAME';

In the above query, replace YOUR_TABLE_NAME with the name of the table you want to query. This SQL query statement will return the tablespace name where the specified table resides.

Alternatively, to view all tables and their corresponding table spaces, you can run the following SQL query:

SELECT table_name, tablespace_name 
FROM user_tables;

This will list out all tables in the database along with their respective table spaces. Please note that these query statements assume that you have enough permissions to query table and table space information.