FND_LOBS reclaim space
Hi All,
EBS R12.1.3 , DB 11.2.0.2 RAC 2 nodes
I have recently Reclaimed the space from FND_LOBS table , but even after this , Total allocated space showing 135 GB , and when i see the space occupied is 61G only, please help in this how can i get back the space. I followed note
select 
  owner                  username, 
  segment_name           segment_name, 
  segment_type           segment_type, 
  bytes/1024/1024/1024   Gbytes, 
  extents                extents 
from 
  dba_segments 
where 
  segment_name ='SYS_LOB0000034032C00004$$' 
USERNAME SEGMENT_NAME SEGMENT_TYPE GBYTES EXTENTS
APPLSYS SYS_LOB0000034032C00004$$ LOBSEGMENT 135.297607421875 1108358
select sum(dbms_lob.getlength(file_data))/1024/1024/1024 GB from applsys.fnd_lobs;
