: Here's a simple request. The request takes into account the size of the table, including indexes, lobs and nested tables. select '&TABLE' as table_name, sum(dba_segments.BYTES) / 1024 / 1024 as Mbfrom dba_segmentswhere (dba_segments.owner, dba_segments.segment_name) in ( -- table select '&OWNER' as owner, '&TABLE' as segment_name from dual ...  #Promote the Blog ora-20000.blogspot.com 
Share to Promote this Blog