How to reduce FND_LOBS growth - PO attachment?

user12077983 · Aug 11, 2011 2:30PM

Kanda-Oracle · Aug 12, 2011 3:25AM

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 · Aug 12, 2011 3:28AM

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

EBS Customizations (MOSC)

How to reduce FND_LOBS growth - PO attachment?

Comments

Category Leaderboard

Top contributors this month