Shrink Lob segment

SQL> SELECT b.owner,b.table_name,b.column_name,a.segment_name, a.bytes

FROM dba_segments a JOIN dba_lobs b on A.SEGMENT_NAME=B.SEGMENT_NAME

and B.SEGMENT_NAME='SYS_LOB0000064465C00005$$';

SQL> ALTER TABLE COGNOS.CMDATA MODIFY LOB (DATAPROP) (SHRINK SPACE);

SQL> SELECT b.owner,b.table_name,b.column_name,a.segment_name, a.bytes

FROM dba_segments a JOIN dba_lobs b on A.SEGMENT_NAME=B.SEGMENT_NAME

and B.SEGMENT_NAME='SYS_LOB0000064465C00005$$';