Break a table into small finite tables

[krishna]

Hi Oracle Xperts,

I am trying to break a 10 million accounts table into 5 tables with 2
million accounts each. I tried using rownum but am having problems
with it. Is there any other way that I can do this?

Many thanks,

Krishna.

[Alan Mills]

Re: Break a table into small finite tables


"krishna" <andhravodu@hot mail.comwrote in message
news:338a9541.0 307210625.7513d 74c@posting.goo gle.com...

Hi Oracle Xperts,
>
I am trying to break a 10 million accounts table into 5 tables with 2
million accounts each. I tried using rownum but am having problems
with it. Is there any other way that I can do this?
>

Probably better would be to stripe the data based on your indexs and usual
queries.

I.e., if it's accounting data then stripe it by month. Maybe your account
data could be striped by region code or something. This will help in your
regional totals etc (or month to date figures).

Also, it can then stay as one large table but striped over different
physical disks giving better regional response times. Work it into the
indexes you already have defined.