Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8 LOB's (Large Objects)

Re: Oracle 8 LOB's (Large Objects)

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 13 Sep 1999 09:18:41 -0400
Message-ID: <EvncN3Q=l+VDdqHMKrWSLQ7bG+wy@4ax.com>


A copy of this was sent to "tba" <tab_at_ccieurope.com> (if that email address didn't require changing) On Mon, 13 Sep 1999 13:45:55 +0200, you wrote:

>Hi,
>Has anybody had any experience with the Oracle 8 LOB feature ?
>Particularly the following aspects :
>
>1) Is it possible to configure the actual storage file paths for the
>objects, and in the event of an excessive number of objects (1 million or
>more), is it possible to specify a hashing function, enabling Oracle to
>spread the storage of the objects across multiple directories ?
>

CLOBs and BLOBs are stored in the database -- not in the file system. They are not stored in a 'directory' in the database.

BFILES, to which we supply read only access, are stored in the file system but it is up to you to put them there in the first place. Oracle wouldn't hash it -- you would when you put them there (as you cannot put them there from within the database).

>2) Is it possible to specify some kind of compression/decompression
>function which will be automatically performed by insert/upate/select of a
>given object. It would be desirable if this was performed in a
>completely transparent manner, from the user point of view.
>

with extprocs, it would be doable in C. You can do this with Java in Oracle8i, release 8.1 as well.

>3) Does standard API's exist, for extracting e.g.TIFF headers or EPS
>tags from a BLOB?
>

That is the Intermedia option of Oracle8i release 8.1 or the Image cartridge of Oracle8.0 (basically the same functionality renamed and bundled differently).

>Responses posted to my email address will be highly appreciated.
>
>Thanks
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 13 1999 - 08:18:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US