Skip to main content

Hi

I was just wondering if someone could help me. We have some media items which are filling up the database size rapidly. I was just wondering would it be possible to create an Oracle Directory with a file share to export/remove all Media Images from the database? I was thinking this could be some type of Background job that could run nightly. Would this be possible? 

Thanks

Gary 

This should certainly be possible to do using custom events and/or background jobs. You need to learn how to read a BLOB (the media content) and write that to the directory, perhaps using UTL_FILE. You should be able to search the internet to find the pieces you need.

There is also a built-in media archiving feature you could use, but it requires an Azure Storage account. Also, it will be replaced with proper Azure Storage support for media items in IFS Cloud 21R2.