Oracle table size

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 vote338 views1 answer
How to convert external table to managed table in hive
SQL
0 vote279 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
1 vote324 views1 answer
Mysql text to decimal
SQL
0 vote280 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote252 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
1 vote280 views1 answer
Sql delete all values in a column
SQL
0 vote305 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote288 views1 answer
Sql server convert date to weekday
SQL
1 vote308 views1 answer
Get create table query existing table mysql
SQL
0 vote274 views1 answer
Postgresql copy backup table
SQL