Re: Large Databas Question

Hi,

You should not split table and store BLOB in separate table. Oracle makes it for you - large BLOBs are stored in separate BLOB segment automatically.

Andrew Protasov

> We are about to create a system using Oracle 8 that will be at least
> 90 GB at is inception. I am curious if any one could offer some Broad
> advice on creating and managing large tables. Ou application will be
> used to store image data consisting of fiels about 50KB each in size.
> The database will grow by about 300,000 images per year.
>
> I have looked at some of the Oracle documentation and partitioned
> tables may be a key factor. How would you recommend applying this? I
> think that a partitioned table of indices with each record pointing to
> an image record in another table. I assmue we know that you can store
> blobs and other objects in a partitioned table.
>
> Given that brief discussion what other factors should be considered?
>
>
> ____________________________________________________
> David Davis 703-437-7921
>
> ___________________________________________________
>
>
Received on Mon Dec 07 1998 - 02:30:28 CST