To view table storage size of all tables in schema

declare
sz varchar2(100);
begin
for i in (select table_name from user_tables) loop
select bytes/1024/1024 into sz from user_segments where segment_name=i.table_name;
dbms_output.put_line(i.table_name || ':' || sz || 'MB');
end loop;
end;
/

Sphere: Related Content