How do I store about 695 signs inventory photo images from a PDF file to
an Oracle database table? We are using Oracle 10.2.0.2. What data type
should I use for these images? How about the table space? What table
space should I allocate to ensure there is no space issue?
Thanks in advance for any/all the help.
Given that you said that you were on 10.2 then here are a couple of
links showing exactly how to go about load images from files ON THE
DATABASE SERVER into a BLOB column in a table in a database.
Now, as to how to size said tablespace that the table lives in, think of
a number, then double it!
Seriously, unless you are compressing (before loading?) then the table’s
image will be about the same size as the image on disc, plus a “bit” of
Also, and I’m not 100% sure that this is (still) correct, editing a *LOB
column results in huge space overheads as the original is not edited in
place, but is copied elsewhere and a new *LOB row inserted in it’s place.
I would create table in normal tablespace, and make the BLOB column (and
index - there will be one!) live in a separate LOB tablespace set up
purely for that purpose.
Check out the LOB Storage clause on creating the table.