TABLE SIZE
select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’;
select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’ and owner='UK';
select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’;
select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’ and owner='UK';
No comments:
Post a Comment