Oracle table size

SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
FROM dba_extents e
WHERE
  e.OWNER = 'SCHEME_NAME' AND
  e.TABLESPACE_NAME = 'TBS_NAME' AND
  e.SEGMENT_NAME IN ('TABLE_NAME')
GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;

Similar codes

0 vote180 views1 answer
How to change null display in psql
SQL
0 vote171 views1 answer
Get server date mysql
SQL
4 votes248 views2 answers
Sql display today's date
SQL
1 vote188 views2 answers
Group_concat limit mysql
SQL
1 vote196 views1 answer
Sql drop schema
SQL
9 votes377 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote179 views1 answer
Pl sql constraint user function
SQL
0 vote176 views2 answers
Null value in column violates not-null constraint
SQL
8 votes192 views2 answers
Grant all privileges database postgres to user
SQL
0 vote181 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL