Database Administration (MOSC)

MOSC Banner

Bytes in user segment still in use after deleting content of BLOB field

edited Nov 30, 2009 1:44AM in Database Administration (MOSC) 2 commentsAnswered
 Hello,
I have a table XXX with following columns:

OBJID NUMBER(10),
OBJFILE BLOB

The table was first filled. After deleting ALL content of the column OBJFILE, I was suprised to see, that in the user segment are still bytes in use,
although the blob field of each row is definitly empty:

SQL> select bytes/1024/1024 as MB, blocks, substr(s.segment_name,1,30) as Name,s.segment_type from user_segments s where s.segment_name='XXX';

        MB     BLOCKS NAME                           SEGMENT_TYPE
---------- ---------- ------------------------------ ------------------
         7        896 XXX                            TABLE

Has anybody an idea, when these bytes of this user segment will be released or what I can do to release these bytes?

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