/SQL/Query to find table size in oracle 12c

Query to find table size in oracle 12c

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

1 vote149 views1 answer
Oracle grant on all tables in schema
SQL
0 vote145 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote173 views1 answer
When mysql server would not work in xampp
SQL
0 vote136 views1 answer
Mysql date minus 1 day
SQL
0 vote227 views1 answer
Mssql unique key accept nulls
SQL
1 vote138 views2 answers
String to date postgres
SQL
2 votes128 views2 answers
Get all columns from table sql
SQL
0 vote165 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote159 views1 answer
Create table like sql
SQL
5 votes139 views1 answer
Oracle ORA-00054 origin
SQL