Re: 40 Million rows?

From: S V <sv_at_phystech.com>
Date: Wed, 15 Apr 1998 22:12:12 -0400
Message-ID: <6h3pe9$i6h$1@m5.columbus.rr.com>

Ken Leach wrote in message <3534C468.2DFF787F_at_ids.net>...
>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....
>
>Suggested hardware?
>
>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!?
>
>From what I know of the data there are about 10 columns, and number or

10 columns x 40M rows?
It's not huge.
Anyway you may try to split it into separate tables by some criteria (say by year or year-month) and then create a partition view with UNION ALL on all those separate tables. This is for Oracle 7.3. In Oracle 8 I would just go for partitioned table

Sergei

>char's. The data will remain static just need to create views and do
>query's off it...
>
>ANY suggestions are welcome.
>
>-Ken Leach
>
Received on Wed Apr 15 1998 - 21:12:12 CDT