Skip to Content
0
Mar 17 at 03:47 PM

SAP ECC on Oracle - large LOB segment on TST03

283 Views

Hi,

SAP ECC system running on Oracle & Windows.

After some uncontrolled spool activity and subsequent housekeeping, we are left with table TST03 having a table size of around 2Gb (which is fine) but the LOB segment on the DCONTENT field is around 200Gb.

What is the recommended approach to reduce this - reorg the table, or shrink the LOB segment?

Thanks!