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 vote349 views1 answer
Sql contains vs like
SQL
0 vote372 views1 answer
On delete set default
SQL
0 vote364 views1 answer
Connexion mysql
SQL
0 vote396 views1 answer
Sqlcl format
SQL
1 vote370 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote360 views1 answer
C# add a textbox in mysql select
SQL
0 vote345 views1 answer
Mysql grant user wildcard database
SQL
0 vote391 views1 answer
How to install sql in anaconda
SQL
0 vote336 views1 answer
Sql query to delete row by id
SQL
0 vote350 views2 answers
How to check if sqlite table exists in nodejs
SQL