[Solved] Row Count and Size For Each Table Under Oracle Schema [closed]

by

[ad_1]

select     table_name,     num_rows, bytes/1047586 MB
 from     dba_tables t
Inner join dba_segments s
  On table_name =segment_name and t.owner =s.owner
Where segment_type="TABLE"
And s.owner="schema"

0

[ad_2]

solved Row Count and Size For Each Table Under Oracle Schema [closed]