Yesterday, I ran alter table tablename drop partition partition name commands on a table which is partitioned on a date
so today I just wanted to know what is the size of the table
why am I not seeing that table in user_segments after the alter table drop partitions done ?
select \* from user\_segments where segment\_type='TABLE' and segment\_name like 'xyz%' order by segment\_name
Using the below sql for calculating the size in gb
select segment_name,sum(bytes)/1024/1024/1024 GB from user_segments where segment_type='TABLE' and segment_name = 'xyz' group by segment_name