the EXT_FILE_TRANS_TAB is taking more and more space in the the database and we do not have a clue about how to clean or purge it, it looks that there is still in the table row related to load file ID that are no more available in EXT_FILE_LOAD.
Does anyone already meet the same issue and/or knwo how to clean the EXT_FILE_TRANS_TAB
thank you in advance for any help, comment or remarks
Hi,
I have a faint memory (This was > 10 years ago...) that we found a load job that will “unload” or truncate the EXT_FILE_TRANS_TAB that is scheduled as any other file load jobs.
/H
Hi,
I have a faint memory (This was > 10 years ago...) that we found a load job that will “unload” or truncate the EXT_FILE_TRANS_TAB that is scheduled as any other file load jobs.
/H
Your memory is correct. There is a file template you can run to clean up old transactions:
Make sure to enter the number of days on the templates you want to clean out transactions for and also determine if you want to include file log in the cleanup by ticking “Remove Completely”:
thank you guys that the first promising answer i get including IFS cloud support and our Consultant
Does someone face a problem with using this cleanup method? With over 60GB of data to remove it is not possible to purge this table. Snapshot to old errors occured.
This has nothing to do with the application itself, this relates to how the Oracle DB is configured.
Try to run the first large cleanup when there is less other transactions in the db.
Also perhaps increase db parameter UNDO_RETENTION and maybe increase size of UNDO datafiles.
Is there a “date” on the “remove job”? - to remove data in smaller chunks?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.