Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: blob filenames?
BLOBs store arbitrary binary data. To give that data name and type and
store them somewhere in the database is up to the developer. Such
information is not stored along with the BLOB automatically because
the BLOB can be anything, not necessarily file.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "John" <jriker1_at_yahoo.com> wrote in message news:e6bb5a8d.0212031445.4f351c2f_at_posting.google.com...Received on Thu Dec 05 2002 - 04:42:19 CST
> I received a dump of a database that has a blob field. I used a
> program that exports the binary data and saves it as tablename.# where
> # is an increasing number per file. I have no idea what the original
> filenames are or even what extension these files are. Is this
> information normally stored in the blob column itself, or would the
> original programmer of had to save that in a column somewhere as it
> isn't in the one the blob is in. Thanks.
>
> JR