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
table, but that would mean that one document is one table. BLOBS and
CLOBS are fast if you know how to handle them. Unfortunately, oracle
no longer provides options for storing LOB index.
On 2003.08.20 21:49, Joan Hsieh wrote:
> Thanks Stephane,
>
> I am new to this system, I think it was stored in blobs but I was told it was
>
> too slow and need to think a new way to handle this type operation. So bfiles
>
> is the right way to go?
>
> Joan
> Quoting Stephane Faroult <sfaroult_at_oriole.com>:
>
> > Joan Hsieh wrote:
> > >
> > > Hi Listers,
> > >
> > > We have a new advance system (fund raising) that needs to read a lot of
> > > word document in the database. I am not sure how it stored or how to
> > > pointed to the word document. Does anyone know anything about that how
> > > to store or how to link to the word document from oracle 9i database on
> > > UNIX?
> > >
> > > Thanks and Regards,
> > >
> > > Joan
> >
> > Joan,
> >
> > It will be BLOBs (in the DB) or BFILEs (outside). Read on Intermedia
> > too.
> > --
> > Regards,
> >
> > Stephane Faroult
> > Oriole Software
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stephane Faroult
> > INET: sfaroult_at_oriole.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: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> 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).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
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).
Received on Wed Aug 20 2003 - 21:14:26 CDT
