Re: PDF files in Oracle database

From: <lyall_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 13:04:15 GMT
Message-ID: <6pn6kg$eil$1_at_nnrp1.dejanews.com>


In article <6pmu7m$58s$1_at_nnrp1.dejanews.com>,   jvdsnickt_at_skynet.be wrote:
> In article <6pkfkh$igo$1_at_nnrp1.dejanews.com>,
> lyall_at_my-dejanews.com wrote:
> > In article <6pja67$6a5$1_at_nnrp1.dejanews.com>,
> > rnbernardo_at_my-dejanews.com wrote:
> > > I'm just wondering if it's possible to store PDF files within the Oracle
> > > database, and if so, what client software can be used to view it. Our
> > > department is about to scan and convert tons of hardcopy documents to PDF
> > > format (for archiving purposes) and since we are migrating to Oracle very
> > > soon, I just want to know is Oracle can handle such files. Anybody know?
> > >
> > > Ray
> > >
> > > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> > >
> >
> > Anything can be store in Oracle tables. They have a data type called Long
> > which can store up to 2 to the power 31 - 1 bytes... or 2 GIG! It just
> > stores variable length data of any type. You can only use one LONG column
in
> > a tables... at least in Oracle 7.x. There is another called LONG RAW that
> > contains raw binary data, but is otherwise the same as LONG columns. These
> > values must be in HEX notation. I don't know too much about this data type.
> > If you look at some of the system tables, like DBA_TRIGGERS, it uses LONG
> > datatype to store the source code for the trigger... which can get pretty
> > big.
> >
> > HTH
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >

>

> Watch out with the use of LONG RAW. Recently I've been testing this and I
> am experiencing tremendous performance problems. Inserting as well as
> searching seems to be extremely slow. If I didn't make some sort of mistake in
> my tests - and it doesn't seem like that - this approach will be unusable for
> my purpose (storing lots of images together with structured descriptive
> information).
>

> Jo
>

> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

True enough, you have to be careful. Clusters are good sometimes, indexes are almost a must. Talk to your (Ray) DBA and find out what they think. Is it a good idea? What is the best option to use? It can bring DBA's many headache's if improperly implemented.

Lyall

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 15:04:15 CEST

Original text of this message