Re: question on how to retrive document

Ok, in that case it's nice - you can index your BFILEs and retrieve them using other methods such NFS or webserver accessing files directly....

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, August 22, 2003 12:34 AM

> Yes, context can index BFILEs. We used in to index a collection of pdfs.
> This is probably not fastest way of reading data, but it is not always a
> goal.
> Vadim
>
> -----Original Message-----
> Sent: Thursday, August 21, 2003 5:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Agree.
> When using NFS or any other OS file sharing mechanism, then there's no
point
> of using BFILEs at all.... Or is context catrtidge/oracle text able to
index
> contents of bfiles?
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, August 21, 2003 7:59 PM
>
>
> > Tanel, if you use oracle to read BFILE's, you're no faster then by
reading
> > normal LOB's,
> > because the mechanism is exactly the same: DBMS_LOB.READ into a buffer
and
> > buffer sent to
> > you through Oracle*Net. The only way that you can be faster then that is
> to
> > read the file
> > name from a normal VARCHAR2 variable and then bypass oracle in accessing
> > that file, and
> > access it through some non-oracle mechanism,typically NFS or CIFS
(Samba).
> > Oracle database
> > is created for reading structured tables by means of SQL, not for
reading
> > plain files.
> > To read a plain file, you will use software designed exactly for that
> > purpose. It's called
> > "file system".
> > Both NFSv3 and Samba V2 can beat oracle hands down in speed of
> > reading/writing files to
> > a remote node. What Samba and NFS cannot do is to retrieve record sets
> from
> > those files
> > using SQL. They can help you to bulk read the file into a document
> processor
> > and nothing
> > more. if speed is all that matters, you read the file name from oracle
and
> > then read the
> > file by using appropriate tools like NFS, Samba or something else.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> >
> >
> >
> > -----Original Message-----
> > Tanel Poder
> > Sent: Thursday, August 21, 2003 11:55 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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).
> >
> >
> >
> > Note:
> > This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> > Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> > INET: mladen_at_wangtrading.com
> >
> > 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).
> >
>
>
> --
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gorbounov,Vadim
> INET: vadim.gorbounov_at_liberate.com
>
> 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).
>

-- 
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).