Re: 40 Million rows?

Ken Leach <KLeach_at_ids.net> wrote:
> I have the need to create a table in Oracle 7.3.4 for NT that will hold
> over 40 Million rows...
> I have never worked with a table so huge.. what suggestions do you
> have....

No problem. We have tables significantly bigger than that on the same Oracle and OS versions.

> Suggested hardware?

Lots of disks! ;-)

> The current data will be given to me in a text file and I will have to
> populate the table somehow, I was thinking of writing a quick little
> delphi application for that. However I am more concerned with how to
> set up Oracle to accept such a HUGE table!?

To populate the table you should probably use SQL*Loader -- this is exactly what it's for! SQL*Loader in direct mode will get the table loaded very quickly.

As far as "setting up" Oracle is concerned -- just create a big-enough tablespace, and use a relatively large extent size. Say, 100mb extents, in a tablespace made of several 1601mb data files. (I don't like to use data files that are /too/ big because it sometimes becomes unwieldy to administer them. The "extra" 1mb allows for the header block in each data file.) And of course set up a different tablespace on different disks for the indexes.

Let's see ... we have a table with about 53.8 million records; it's taking 54 100mb extents at the moment.

-bn
(the domain is really "enteract") Received on Wed Apr 15 1998 - 11:55:47 CDT