Re: Blob versus Server Directory

Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote in message news:<3EBFC28B.2493021E_at_ram.lmtas.lmco.com>...
> I have a need to have users save files that are associated with
> particular records. We are talking about any file types, e.g *.html,
> *.doc, *.gif, *.vsd, *.mpp, and many more.
>
> I understand there are a couple ways to do this:
> 1) actually save the file as part of the record in an Oracle Blob field.
> Never done this before. If you have any examples this would be great.
> 2) for each record, create a directory on a server identified by the
> record ( the key id ) and store that file out in that directory server.
> Save the name of the file stored on the directory in an Oracle text
> field.
>
> Anyone want to comment on which of these methods you think is preferred?
>
> I can do 2), but I have never implemented 1) above.
>
> Mike

1. Oracle provides documentation. There are usually examples in the documentation. Try to use it
2. Better use a BFILE instead of your own mechanism Obviously 2 is preferred as it takes less space and your table is not going to be subject to chaining.

Regards
Sybrand Bakker
Senior Oracle DBA Received on Tue May 13 2003 - 09:31:23 CEST