/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 vote200 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote194 views1 answer
Mysql where in keep order
SQL
0 vote206 views1 answer
Define a variable in mysql from select
SQL
19 votes200 views5 answers
Date between in mysql
SQL
-1 vote198 views1 answer
Adding a new table psql
SQL
0 vote189 views2 answers
Mysql update two tables at once
SQL
4 votes253 views1 answer
Alter session set nls_date_format
SQL
0 vote185 views1 answer
Oracle archivelog usage
SQL
0 vote188 views1 answer
Postgre admin slow
SQL
-1 vote197 views1 answer
How to create foreign key in sql server management studio
SQL