Empty table in DBA_SEGMENTS
Hi All
Kindly, I have an empty table with zero rows, when I try to check the size of the table I can see it's 1 GB,
MY DB 11.2.0.4
This is the SQL I am using to get the table size:
SELECT Segment_Type ,Owner ,Segment_Name ,(Bytes / 1024 / 1024) Mb ,Tablespace_Name FROM Dba_Segments WHERE Segment_Type = 'TABLE' AND Segment_Name = 'EIM_SRV_REQ'
Is this statement correctly showing the table size?
Is this 1 GB consuming space from the tablespace? if yes, should I execute any statement to shrink the consumed space?
Thanks ...