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 vote276 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote257 views1 answer
Flask sqlalchemy decimal
SQL
-1 vote253 views1 answer
MYSQL stored procedure select from
SQL
4 votes308 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
1 vote280 views1 answer
Login to database mysql terminal
SQL
0 vote279 views1 answer
Timestamp(0) postgresql
SQL
0 vote303 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
4 votes275 views4 answers
Rollback in sql
SQL
0 vote258 views1 answer
Oracle sql procedure return value
SQL
0 vote281 views1 answer
Sql cmd no truncate
SQL