/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

0 vote357 views1 answer
Convert int to varchar sql
SQL
2 votes375 views6 answers
Mysql change timezone
SQL
1 vote336 views1 answer
Lpad function in sql oracle
SQL
1 vote339 views2 answers
Setval max id postgresql sequence
SQL
0 vote385 views1 answer
Oracle insert single quote in string
SQL
2 votes358 views1 answer
Sql update from different table
SQL
22 votes380 views3 answers
How to join three tables in sql using joins
SQL
6 votes349 views3 answers
Commit in sql
SQL
0 vote363 views3 answers
Database restoring error
SQL
0 vote354 views1 answer
Write a query to peint the pattern P(20)
SQL