/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

4 votes178 views3 answers
Sql drop primary key
SQL
0 vote170 views2 answers
Sql drop view if exists
SQL
0 vote180 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
13 votes171 views4 answers
Mysql select last 10 rows
SQL
0 vote185 views1 answer
Oracle table privileges
SQL
1 vote201 views1 answer
How do you use sql in you company
SQL
6 votes224 views3 answers
Rename column ORACLE
SQL
0 vote166 views4 answers
First max salary in sql
SQL
1 vote191 views1 answer
Events mysql
SQL
0 vote177 views1 answer
Describe in sqlite3
SQL