1

I am working on a web application using JSP.

I want to ask which datatype(with syntax) is used to store video files in Oracle database.

2
  • 1
    What database engine are you using? Apr 17, 2017 at 4:14
  • I I am using ORACLE 10g
    – user122808
    Apr 17, 2017 at 4:19

2 Answers 2

0

You probably shouldn't be storing the video in the database at all. Just store the metadata about it in the database and put the video itself on a filesystem, which is much more appropriate for storing such stuff.

More details in the two good answers at Images, PDF, audio and video files in MySQL - of which this question is arguably a duplicate.

2
  • 1
    interMedia is largely used to do what I'm suggesting: put the video in the filesystem (using Oracle's BFILE type) and store the metadata about it in the database; it just allows one to do it in one of Oracle's several-somewhat-standard ways. The pros and cons of storing the data as a BLOB within the database given at the question I referred to are quite apropos; that it's about MySQL is irrelevant. Apr 17, 2017 at 5:03
  • 1
    It's fabulous suggestions I got it thanks to all IT genius
    – user122808
    Apr 17, 2017 at 5:52
2

Oracle Multimedia (formerly known as Oracle interMedia) lets you write applications to manage images, audio,video, and other heterogeneous media data in Oracle databases.

I have referenced interMedia as you are using Oracle 10g.

interMedia User's Guide

Here is a nice answer given by Justin Cave, which explains why would a person store a video file in a BLOB in a database and what are the advantages and disadvantages compared to storing pointers to the location of the video file.

BLOB's in SQL that stores a Video file

2
  • 1
    Doing it this way would lock you into using Oracle; it would become hard to switch to another DBMS? Apr 17, 2017 at 5:08
  • 1
    @MatthewElvey do folks just switch databases every day? if you're going to use a platform, use it to the best of its ability, not to the lowest common denominator..and yes, i'm biased Apr 18, 2017 at 21:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.