Table size after purge
Hello,
I have big table, her size before purge is 6.4453125 Go
and I delete more (1 Billion data) in this table and when select his size :6.4Go
This my query :
select segment_name table_name,
sum(bytes)/(1024*1024*1024) table_size_Go
from dba_extents
where segment_type='TABLE'
and segment_name = 'TAB_LOG'
group by segment_name;
But when I export this table I see that his size is
. . exported "ACC"."TAB_LOG" 750.9 MB 11658895 rows
What should I do, to the table have its true size
Thanks for you help.
I use Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Best regards,
I have big table, her size before purge is 6.4453125 Go
and I delete more (1 Billion data) in this table and when select his size :6.4Go
This my query :
select segment_name table_name,
sum(bytes)/(1024*1024*1024) table_size_Go
from dba_extents
where segment_type='TABLE'
and segment_name = 'TAB_LOG'
group by segment_name;
But when I export this table I see that his size is
. . exported "ACC"."TAB_LOG" 750.9 MB 11658895 rows
What should I do, to the table have its true size
Thanks for you help.
I use Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Best regards,
0