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_tables
vinish.ai Latest Articles
Oracle: Getting Current Table Size and Extent Information
VinishIn Oracle, you can use the user_extents and user_tables dictionary views to get the current table size and extent information. Below is an example: Oracle SQL Query to Get the Current Table Size and Extent Information The following query returns ...