How to reduce FND_LOBS growth - PO attachment?

user12077983

Kanda-Oracle

Refer the below link for the similar discussion

Purge APPS_TS_MEDIA

Refer the below link to know how to defragment. This will free up some additional space.

what is the best way to shrink the space in such of huge lob segement?

Additional reference.

Note.555463.1  How to Purge Generic or Purchasing Attachments from the FND_LOBS Table

Note.371342.1  Why does the EXPIRATION_DATE column of FND_LOBS table have NULL entries?

Note.829235.1  FAQ - Performance considerations for FND_LOBS

Thanks

N Kandasamy

Kanda-Oracle

Refer the below link for the similar discussion

Purge APPS_TS_MEDIA

Refer the below link to know how to defragment. This will free up some additional space.

what is the best way to shrink the space in such of huge lob segement?

Additional reference.

Note.555463.1  How to Purge Generic or Purchasing Attachments from the FND_LOBS Table

Note.371342.1  Why does the EXPIRATION_DATE column of FND_LOBS table have NULL entries?

Note.829235.1  FAQ - Performance considerations for FND_LOBS

Thanks

N Kandasamy

Hi

Q1: How can one purge Purchasing attachments related to old documents from the FND_LOBS table?

A1: Purchasing does not set an expiration date on the attachments. Also, there is no concurrent request available currently that deletes Purchasing attachments in bulk. Enhancement Request Bug 3899857 is already logged with Oracle Development requesting this functionality.

Refer Note 555463.1 How to Purge Generic or Purchasing Attachments from the FND_LOBS Table 

Hope this answers!

Thanks

N Kandasamy