Re: question on how to retrive document

Hi!

> Of course, you could give IFS a shot. I would still go with CLOBS if
> I were you. You can do bfiles, but hten you have to set NFS server
> and you can retrieve the document only if you have access to something
> called /docs/oracle/bfile or similar, and that is rather hard to do
> from an NT station. You can also store an ASCII file as an external

You can read BFILEs without having client access to the file. As long Oracle has access to the file, it can open it & stream it to you. But if you want write access to these files you have to do it from OS or with utl_file or similar packages. Gets too complicated to use if your end users want to modify those docs, but it could work if you're loading your doc's once and they are only read afterwards.

But yes, internal lobs can be fast if implemented properly.

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).