/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 vote203 views2 answers
Sql server Insert Into table
SQL
3 votes199 views1 answer
Mssql remove column
SQL
0 vote196 views1 answer
Mysql set column equal to another automatic
SQL
13 votes235 views2 answers
Oracle inner join
SQL
0 vote223 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote252 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote233 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote286 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote196 views2 answers
Sql for date greater than
SQL
1 vote205 views1 answer
Sql order by where condition
SQL