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$$';

 

OWNER

TABLE_NAME

COLUMN_NAME

SEGMENT_NAME

BYTES

COGNOS

CMDATA

DATAPROP

SYS_LOB0000064465C00005$$

595591168

 

 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$$';

 

OWNER

TABLE_NAME

COLUMN_NAME

SEGMENT_NAME

BYTES

COGNOS

CMDATA

DATAPROP

SYS_LOB0000064465C00005$$

534577152

Comments