You can use the user_tablespaces dictionary view to get the tablespace used by a user in Oracle. Below is an example: SQL Query to Find Tablespace Used by a user in Oracle The following SQL query will not only return ...
Home/user_tablespaces