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 vote310 views1 answer
Mysql export and import
SQL
10 votes308 views1 answer
Oracle object dependencies
SQL
1 vote288 views1 answer
Oracle lowercase
SQL
1 vote336 views1 answer
Login to database mysql terminal
SQL
0 vote323 views3 answers
Remove folders from remote git
SQL
1 vote307 views1 answer
Spring postgresql reset auto increment to 0
SQL
5 votes284 views2 answers
Oracle to_timestamp
SQL
0 vote311 views1 answer
Oracle temporary table
SQL
11 votes345 views1 answer
Oracle export view ddl
SQL
0 vote296 views1 answer
Turnicate in mysql
SQL