Guys, please provide me your wise advice.
OS: RHEL 5.7 x86_64
Oracle DB: 11gR1 64 bits (184.108.40.206.0)
Oracle applications (EBS): 12.1.3
I have worked with other instances of Oracle applications, the “basic” administrative tasks. This time I have assigned to solve a situation related to the APPS_TS_MEDIA tablespace.
The APPS_TS_MEDIA tablespace is huge, this is the detail:
Table and size: FND_LOBS / 1025.375 MB / 6,554,236 rows
LOB segment and size: SYS_LOB0000034032C00004$$ / 274.27 GB
LOB index and size: SYS_IL0000034032C00004$$ / 70.5 MB
I have queried the related tables to get a quick view of the attached documents, these are the results:
By file type:
.out : 7,154 records.
.doc or .docx : 2 records.
.xls or .xlsx : 34 records.
.pdf : 18,760 records.
.xml : 6,472,313 records.
By date of creation:
Before Jan 1st 2015
After Jan 1st 2015
I want to delete (purge) all of the files whose creation date is before Jan 1st 2015.
PS. After purge the attachments I want to reclaim the unused space, but I will ask about it after achieve purge the files.
Thanks for your time and help!
The FND_LOBS table stores attachments in addition to other types of files.
Check the program_name to verify.
Purging data from the table directly is not supported.
You should log a service request for the supported method for each application.
How To Purge FND_LOBS? (Doc ID 871721.1)