By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Break a table into small finite tables

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"krishna" <an********@hotmail.com> wrote in message
news:33**************************@posting.google.c om...
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.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.