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@xxxxxxxxxxxxx> 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@xxxxxxxxxxx>
*Sent:* 11 June 2019 19:35
*To:* Jeremy Ovenden <Jeremy@xxxxxxxxxxxxx>
*Cc:* Oracle Mailing List <oracle-l@xxxxxxxxxxxxx>
*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?
*From: *"Jeremy Ovenden" <Jeremy@xxxxxxxxxxxxx>
*To: *"Oracle Mailing List" <oracle-l@xxxxxxxxxxxxx>
*Sent: *Tuesday, June 11, 2019 10:06:07 AM
*Subject: *Saving MS Office Documents into an Oracle Database?
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.