Re: Oracle glob/blob handling

AcCeSsDeNiEd wrote:

> Hi there.
>
> I'm pretty new to Oracle so plz no flames :)
>
> I have many small files measuring btw 200kb - 500 kb each.
> I expect them to grow to about 20-30 gig a year in total.
>
> I intend to insert them as a glob/binary into the Oracle db.
> Putting them into directories and then linking/refrencing to them is out 'cos of the complexity of
> the database design and the flexibility that is needed in the future to move the files from record
> to record.
>
> 1. Can Oracle handle this? I means in terms of speed & record searches & file retrievals?
> 2. Won't it slow down with such a huge load of binary data?
> 3. Will it get easily corrupted?
>
> I know that MySQL treats each created table as a physical file in the /mysql directory.
> This is for the unix/linux version. Not sure of the M$ version.
>
> If I lump all the globs/files into one table, the particular MySQL table file is going to be very
> big. This makes backups hard too.
>
> 4. Does Oracle also treat each table as a physical file in it's directory?
> How does Oracle handle it's data "behind"?
>
> Thanks a million for the time.

You need to spend a great deal of time with the Oracle Concepts and Architecture manuals available on-line at numerous web site.

But Oracle handles it just fine and stores multiple tables in a single tablespace that can consist of one or more datafiles. Allowing you to design things any way you wish.

If you have 9i you can also look at external tables and other options.

Oracle provides a huge amount of flexibility. What you do with it requires understanding how the beast works.

Daniel Morgan Received on Thu Nov 21 2002 - 17:36:50 CST