Re: Very Large DB

One major problem with keeping some data in Oracle and some in a flat file is backup and recovery. If all of the data is in Oracle, you can restore from a backup and everything would be in sync. If some of the data is outside of Oracle, you could end up with inconsistencies between your Oracle data and flat file data.

Jason D. Weil wrote:

> I am leading a development effort that will result in a multi-billion
> row database, on the order of 400GB. About 80% of this database could
> properly reside in a single partitioned table, each row being fairly
> small. There is some contention within our organization as to whether to
> implement this as a completely relational database (using Oracle 8), or
> to implement the largest table as flat files and use Oracle as a front
> end for accessing these data. Does anyone have experience with this type
> of problem? Have you had success with either of these approaches, or is
> there another, better, candidate?
Received on Thu Mar 26 1998 - 00:00:00 CET