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;