Database Administration (MOSC)

MOSC Banner

Empty table in DBA_SEGMENTS

edited Aug 26, 2020 8:54AM in Database Administration (MOSC) 3 commentsAnswered ✓

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 ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center