/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

6 votes222 views4 answers
Mysql group by date
SQL
2 votes187 views2 answers
Select multiple tables mysql
SQL
0 vote256 views1 answer
Sql select without column name
SQL
1 vote166 views1 answer
Restart identity postgresql
SQL
7 votes209 views3 answers
Select latest entry in sql table
SQL
2 votes217 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote203 views1 answer
Add alternate add column sql
SQL
1 vote198 views1 answer
Sql server select rows by distinct column
SQL
3 votes197 views2 answers
Plsql print
SQL
0 vote188 views1 answer
Postgresql get current user name
SQL