Hi @sara19 , When analyzing the logs, the reason for this there is not enough tablespace for IFS_LOB. At least make it 100GB. When we are analyzing the error log, we can see bellow error here. ORA-01691: unable to extend lob segment IFSAPP.SYS_LOB0000347073C00013$$ by 1024 in tablespace IFSAPP_LOB In this case of an ORA-01691 error, the solution is to identify the name of the tablespace associated with the LOB segment and add space to the tablespace. Please check it with your DBA and increase the enough tablespace for this. 1024 is not enough for this. We have suggested bellow options, You can enable “Oracle Advanced Compression” from oracle. You can enable "Shrink Lob Segments". You already did it. Please follow my above note and increase the table space and try it. Remember that, if you run this job for the first time, it will take a large amount of time (May be about two days) to complete. When you schedule the “Shrink LOB Segments” database task to be run, please set it in a non-pe
Hello @sara19 , There is a separate database task used in IFS which is called “Shrink Lob Segments” to handle large sized LOBs. Normally we are not recommended to run the Shrink Lob Segments in app 10. But, from Oracle 12C onwards, there’s a mechanism called “Oracle Advanced Compression” is available to handle large sized objects in a Database. Further, if you are using Oracle Enterprise Edition, you can enable "Advanced Compression" which will reclaim the space and will most certainly also improve the performance automatically via Oracle. Also, you can refer the explanation given by Oracle: https://oracle-base.com/articles/misc/alter-table-shrink-space-online Can you disable the "Shrink Lob Segments" job and enable Advanced Compression mechanism in Oracle. It'll resolve your issue. For more details refer bellow note as well. We were able to identify why the "Shrink Lob Segments" job fails for table 'FNDCN_MESSAGE_BODY_TAB. In IFS Applications 10 any LOBs are stored as Oracle "Secure
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.