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.
-
1What database engine are you using?– Mr.BrownstoneCommented Apr 17, 2017 at 4:14
-
I I am using ORACLE 10g– user122808Commented Apr 17, 2017 at 4:19
Add a comment
|
2 Answers
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.
-
1interMedia 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. Commented Apr 17, 2017 at 5:03
-
1It's fabulous suggestions I got it thanks to all IT genius Commented Apr 17, 2017 at 5:52
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.
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.
-
1Doing it this way would lock you into using Oracle; it would become hard to switch to another DBMS? Commented 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 Commented Apr 18, 2017 at 21:47