Find Used Size in a table

This script contains the query to get the size (size) used by a table in MB 


SELECT
   segment_name           table_name,   
   sum(bytes)/(1024*1024) table_size_meg
FROM  user_extents
WHERE segment_type='TABLE'
AND  segment_name = '&table_name'
GROUP BY segment_name


Comments

Popular posts from this blog

Create Tables in Oracle Database using TOAD

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle