Bytes in user segment still in use after deleting content of BLOB field
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?
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?
0