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
|
|