/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 vote281 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote278 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes287 views2 answers
Mysql add hours to time field
SQL
0 vote274 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote267 views1 answer
How to add more columns to a table in mysql
SQL
1 vote270 views3 answers
Nth highest salary
SQL
1 vote276 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote275 views1 answer
Sql developer search all packages for text
SQL
0 vote213 views2 answers
Jupyter notebook connect to database
SQL
3 votes299 views3 answers
Update con select postgresql
SQL