Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to store Excel spreadsheets in Oracle?
Thank you both.
Van
"James Lorenzen -XIOtech Corporation" <jlorenzen_at_my-deja.com> wrote in
message news:9180tl$ivc$1_at_nnrp1.deja.com...
> The iFS (Internet File System) would also work to do this and it has
> many interfaces, FTP, mail, Windows and some others. I looked a tthe
> doc andit does look good for this. An added benefit would by context
> searching with the intermedia options installed.
>
> HTH
> James
>
> In article <3A373583.7634002A_at_ntsource.com>,
> Frank Hubeny <fhubeny_at_ntsource.com> wrote:
> > I considered a similar problem once for images. Unless you have a
very large
> > number of spreadsheets, I would suggest storing only the url in the
database
> > and leaving the spreadsheet in the file system. This would allow
you to
> > conveniently use your normal methods to update the file.
> >
> > As I understand the argument for putting such files in the database,
this would
> > allow you to maintain transactional control over changes in the file
and perhaps
> > even do some searching through these files. For example, if you
wanted to
> > delete the file, both the reference to the url and the file itself
could be
> > removed in a single transaction. Also backing up the database would
backup the
> > file. However, I don't think these benefits outweigh the ease of
updating the
> > spreadsheet if it remained as a file in the file system.
> >
> > Frank Hubeny
> >
> > Van Messner wrote:
> >
> > > What do you all suggest as the most effective way to do this?
Store a
> > > pointer to the document? Store the document? As what - a blob?
And how is
> > > the document reconstituted with all of its formatting intact after
you get
> > > in out of the database? They want to have users hit the database
over the
> > > web and be able to see the spreadsheets they have permissions on.
> > >
> > > Van
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 13 2000 - 17:46:44 CST