RE: Multimedia desupported

You could just move your image to a blob column and continue to store in the database.

Most image types already have compression built into them so compression algorithms normally don’t work real for images depending on the image type.

There are tons of examples online on the simple java code to do this for oracle and other databases.    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Amit Grover Sent: Wednesday, January 13, 2021 5:31 PM To: backseatdba_at_gmail.com
Cc: oracle-l-freelist <oracle-l_at_freelists.org> Subject: Re: Multimedia desupported  

Any solution from here on will need a rewrite, unless u want to replicate data to an older version database and have time to come up with a solution.  

One option if you want to stay on 19c would be, and bite it off now would be, Store the images in S3 and the S3 address in the table column, which can then be fetched by the application with the get call to S3.  

Best Regards

Amit Grover
2065966629    

On Wed, Jan 13, 2021 at 4:52 PM Jeff Chirco <backseatdba_at_gmail.com <mailto:backseatdba_at_gmail.com> > wrote:

We just recently upgraded to 19c and have been using ordssys.ordimage to compress images files saved in the database. Unfortunately we missed the note that Multimedia has been desupported in 19c. Oracle docs recommend to use https://www.apexmediaextension.com/index.html

Which is a paid option but was wondering if anyone else has run into this issue and came up with some other solutions.  

Link to Oracle Docs about the desupport

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/behavior-changes-deprecated-desupport-oracle-database.html#GUID-BABC1C60-EA07-4EBE-8C67-B69B59E4F742 <https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/behavior-changes-deprecated-desupport-oracle-database.html#GUID-BABC1C60-EA07-4EBE-8C67-B69B59E4F742>  

Thanks,  

Jeff

--
http://www.freelists.org/webpage/oracle-l