How to determine tables size in Oracle

Question

I use Oracle 11 and want to find out the size of my tables  like in megabytes   What should I do  Should I check the file size on server  Or is there any query to run

User · Answer

If you don t have DBA rights then you can use user segments table   select bytes 1024 1024 MB from user segments where segment name  Table name

User · Answer

Here is a query  you can run it in SQL Developer  or SQL Plus    SELECT DS TABLESPACE NAME  SEGMENT NAME  ROUND SUM DS BYTES     1024   1024   AS MB   FROM DBA SEGMENTS DS   WHERE SEGMENT NAME IN  SELECT TABLE NAME FROM DBA TABLES   GROUP BY DS TABLESPACE NAME         SEGMENT NAME

[oracle] How to determine tables size in Oracle

Examples related to oracle

Examples related to oracle11g