lob segment shrink

https://forums.sdn.sap.com/thread.jspa?threadID=1414229&messageID=7891933

https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=821687
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1319517
https://websmp130.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1010237

ESBIGTBL Tablespace is Growing More Than a Giga Per Day [ID 331534.1]


select owner, table_name, column_name from dba_lobs
where segment_name = 'SYS_LOB0000080468C00006$$'


select * from SAPSR3.tst03

SYS_LOB0000080468C00006$$

tst03 112
lob -3.25

alter table SAPSR3.TST03 disable row movement;

alter table SAPSR3.TST03 shrink space cascade;

select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
----------------------------------------------
SOFFCONT1.SYS_LOB0000068056C00007$$ 64G
RSBCS_REORG
RSDBDEOC
SO30 trans (RSBCSRE03 report)

14,4 08.20 GSYS_LOB0000076186C00006$$

alter table SAPSR3.TST03 enable row movement;
alter table SAPSR3.TST03 shrink space cascade;
alter table SAPSR3.TST03 enable row movement;


select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'


SOFFCONT1
so30
RSBCS_REORG
RSSOCVPC

RSSORE00
RSCBCSRE03
RSBCSRE03

ALTER TABLE SOFFCONT1 MODIFY LOB (CLUSTD) (SHRINK SPACE);

select owner, table_name, column_name from dba_lobs
where table_name='SOFFCONT1'
brspace -c force -p initsid.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t TST03
-------------
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool shrink_list
select 'brspace -c force -p initBP3.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t '||table_name from user_tables;
spool off
---------------
http://forums.sdn.sap.com/thread.jspa?threadID=338689

1. Run RSSO_DELETE_PRIVATE - I have run these for Document class RAW and OTF.
2. Run RSSODFRE
3. Run RSBCS_REORG - I have run these for Document class RAW and OTF.

This will delete and clean-up SOC3 and SOFFCONT1.
SOFFCONT1 stores any reports sent thru SAP office / workplace.