Re: size of tables

Posted by ErmanArslansOracleBlog on Jan 04, 2018; 9:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/size-of-tables-tp4804p4807.html

Happy new year roshan.

For finding the size of a table, you can use SQL.

Here is a sql for you:

elect segment_name,segment_type,bytes/1024/1024 MB
 from dba_segments
 where segment_type='TABLE' and segment_name='<yourtablename>';

You can modify this query to display the sizes of all your tables  or you can execute this query for every table in your excel.