Re: Saving MS Office Documents into an Oracle Database?

I'm with Jeremiah here (though not perhaps his image). Windows shared file systems provide centralized secure access to MS Office documents for millions of folks. You absolutely *can *use the BFILE data type, but then you can also generate a URI for the file as well and store than in a simple varchar2. Anyone accessing the URI will be able to view/edit the doc depending on their corporate permissions in a native app.

On Tue, Jun 11, 2019 at 7:43 PM Jeremy Ovenden <Jeremy_at_hireserve.com> wrote:

>
>
>
>
> Heh thanks for reinforcing your view with a useful image.
>
>
>
>
>
> Why would you store anything in a database? Presumably for centralised,
> secure access to data.
>
>
>
>
>
>
>
>
>
> *From:* Jeremiah Cetlin Wilton <jcwilton93_at_earlham.edu>
> *Sent:* 11 June 2019 19:35
> *To:* Jeremy Ovenden <Jeremy_at_hireserve.com>
> *Cc:* Oracle Mailing List <oracle-l_at_freelists.org>
> *Subject:* Re: Saving MS Office Documents into an Oracle Database?
>
>
>
>
>
>
>
> Sorry... just being annoying.
>
>
>
> The question would be: "why?"
>
>
>
> Oracle is a transactional relational database. Why would we keep MS Office
> docs in there?
>
>
>
> Jeremiah
>
>
>
>
> ------------------------------
>
> *From: *"Jeremy Ovenden" <Jeremy_at_hireserve.com>
> *To: *"Oracle Mailing List" <oracle-l_at_freelists.org>
> *Sent: *Tuesday, June 11, 2019 10:06:07 AM
> *Subject: *Saving MS Office Documents into an Oracle Database?
>
>
>
> Hi
>
>
>
> Not sure if this is a the right group to ask for this assistance – but my
> google mojo has failed me thus far.
>
>
>
> In MS Word you can save files to o/s but you can also save to e.g.
> Sharepoint and Teams – I was wondering if there is a means by which you can
> save directly into an Oracle DB?
>
>
>
> Any pointers gratefully received.
>
>
>
> Many thanks
>
> jeremy
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info





--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png