Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Azeem.

Asked: February 06, 2019 - 6:16 am UTC

Last updated: February 06, 2019 - 5:01 pm UTC

Version: 12

Viewed 1000+ times

You Asked

I have been using OrdDoc to store files and attachments for my applications. It looks like Oracle has deprecated this and will no longer support it in its next release ( https://mikedietrichde.com/2018/08/10/oracle-multimedia-is-deprecated-in-oracle-18c/ ). The only guidance that I could find is to convert to LOBs.

I'm looking at all the options available to me for storing attachments/files/images in Oracle. Should I just migrate all of my OrdDoc data to Blobs? Is there a more superior option out there? I'm surprised that Oracle decided to not only deprecate but abandon Oracle Multimedia completely. I thought that it was recommended to use this instead of using Blobs directly for storing images.


and Chris said...

Yes, Multimedia is deprecated in 18c. But it's still supported in this release:

Oracle Multimedia is deprecated in this release, and may be desupported in a future release. This includes all functionality and features of Oracle Multimedia.

https://docs.oracle.com/en/database/oracle/oracle-database/18/imurg/changes-in-this-release-for-oracle-multimedia-users-guide.html#GUID-2A62D7A7-CB56-471E-8F5A-46797D4BD1BF

That said, you should start looking to migrate off Multimedia functionality you're using. Storing images as (securefile) BLOBs is the way to go. I'm not aware of a better option at the moment.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

still life

Racer I., February 06, 2019 - 2:46 pm UTC

Hi,

If there is a rewrite of the application necessary, then, depending on the OPs requirements and control over their environment, they might also look at BFILEs.

regards,
Chris Saxon
February 06, 2019 - 5:01 pm UTC

Yes, you could use BFILEs. Though with these the files live outside the database.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here