/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

3 votes274 views5 answers
Duplicate table sql
SQL
0 vote266 views2 answers
How covert into int in maria db
SQL
22 votes279 views4 answers
Date format mysql
SQL
0 vote254 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote295 views1 answer
Create new table from old table
SQL
0 vote273 views1 answer
Wordpress database query change url
SQL
6 votes251 views1 answer
Sql insert values into table
SQL
16 votes326 views2 answers
Sql vs nosql
SQL
6 votes244 views1 answer
How to count number of rows in sql
SQL
0 vote268 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL