A handful of LOB-holding tables (like PDF_ARCHIVE_TAB, FNDCN_MESSAGE_BODY_TAB, XML_REPORT_ARCHIVE_TAB, XML_REPORT_DATA_TAB) keep growing steadily in size, even with Oracle Advanced Compression available — is there a way to reclaim this space?

All FAQ questions / Platform, Aurena, and customization

Answer

Yes — set up and run the 'Shrink LOB Segments' Database Task specifically built for this. Create a Database Task configured for the Shrink LOB Segments job, then create a Schedule to run it. Important practical notes: schedule it for a genuinely non-peak time, since the first run against a large amount of accumulated LOB data can take a very long time (potentially around two days); after that initial run, scheduling it weekly or monthly (depending on how fast your LOB data grows) keeps it under control going forward.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions