/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

11 votes221 views2 answers
Sql between date range
SQL
9 votes142 views4 answers
How to alter table column name in mysql
SQL
0 vote142 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote143 views1 answer
Sql list dates between two dates
SQL
0 vote138 views2 answers
Create new table plsql
SQL
0 vote179 views1 answer
Insert into table with only identity column
SQL
0 vote150 views1 answer
Compare if is null sql
SQL
7 votes131 views2 answers
Show size database mysql
SQL
1 vote128 views1 answer
Copy postgres table from one schema into another
SQL
0 vote135 views1 answer
Print boolean in plsql
SQL