Purging Lobs
Purging LOBs : If we purge a table which contains LOBs , we may not reclaim space. BLOBs are stored out of line once they exceed 4,000 bytes (you can also specify that they are always stored out of line as well). If the BLOBs were all inline, each taking 4000 or less bytes, then you did free space in your table. The table will not shrink in size (tables NEVER shrink) but it will have more blocks on its free list for subsequent inserts. SQL> desc applsys.fnd_lobs Name Null? Type —————————————– ——– —————————- FILE_ID NOT NULL NUMBER FILE_NAME VARCHAR2(256) FILE_CONTENT_TYPE NOT NULL VARCHAR2(256) FILE_DATA BLOB UPLOAD_DATE DATE EXPIRATION_DATE DATE PROGRAM_NAME VARCHAR2(32) PROGRAM_TAG